Pandas Profiling Report

Dataset statistics

Number of variables	55
Number of observations	1355602
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	568.8 MiB
Average record size in memory	440.0 B

Variable types

Numeric	19
Categorical	36

Warnings

`order_status` has constant value "delivered"	Constant
`declared_monthly_revenue` has constant value "0.0"	Constant
`review_id` has a high cardinality: 4447 distinct values	High cardinality
`order_id` has a high cardinality: 4453 distinct values	High cardinality
`review_creation_date` has a high cardinality: 516 distinct values	High cardinality
`review_answer_timestamp` has a high cardinality: 4447 distinct values	High cardinality
`customer_id` has a high cardinality: 4453 distinct values	High cardinality
`order_purchase_timestamp` has a high cardinality: 4441 distinct values	High cardinality
`order_approved_at` has a high cardinality: 4428 distinct values	High cardinality
`order_delivered_carrier_date` has a high cardinality: 4393 distinct values	High cardinality
`order_delivered_customer_date` has a high cardinality: 4450 distinct values	High cardinality
`order_estimated_delivery_date` has a high cardinality: 402 distinct values	High cardinality
`product_id` has a high cardinality: 3481 distinct values	High cardinality
`shipping_limit_date` has a high cardinality: 4446 distinct values	High cardinality
`product_category_name` has a high cardinality: 66 distinct values	High cardinality
`seller_id` has a high cardinality: 362 distinct values	High cardinality
`seller_city` has a high cardinality: 163 distinct values	High cardinality
`geolocation_city` has a high cardinality: 223 distinct values	High cardinality
`customer_unique_id` has a high cardinality: 4322 distinct values	High cardinality
`customer_city` has a high cardinality: 155 distinct values	High cardinality
`mql_id` has a high cardinality: 362 distinct values	High cardinality
`won_date` has a high cardinality: 354 distinct values	High cardinality
`first_contact_date` has a high cardinality: 141 distinct values	High cardinality
`landing_page_id` has a high cardinality: 70 distinct values	High cardinality
`seller_zip_code_prefix` is highly correlated with `geolocation_zip_code_prefix` and 1 other fields	High correlation
`geolocation_zip_code_prefix` is highly correlated with `seller_zip_code_prefix` and 1 other fields	High correlation
`customer_zip_code_prefix` is highly correlated with `seller_zip_code_prefix` and 1 other fields	High correlation
`product_category_name` is highly correlated with `order_status` and 1 other fields	High correlation
`sr_id` is highly correlated with `order_status` and 1 other fields	High correlation
`origin` is highly correlated with `order_status` and 1 other fields	High correlation
`sdr_id` is highly correlated with `order_status` and 1 other fields	High correlation
`geolocation_state` is highly correlated with `order_status` and 3 other fields	High correlation
`order_status` is highly correlated with `product_category_name` and 14 other fields	High correlation
`lead_behaviour_profile` is highly correlated with `order_status` and 1 other fields	High correlation
`review_score` is highly correlated with `order_status` and 1 other fields	High correlation
`lead_type` is highly correlated with `order_status` and 1 other fields	High correlation
`business_type` is highly correlated with `order_status` and 1 other fields	High correlation
`payment_type` is highly correlated with `order_status` and 1 other fields	High correlation
`business_segment` is highly correlated with `order_status` and 1 other fields	High correlation
`landing_page_id` is highly correlated with `order_status` and 1 other fields	High correlation
`declared_monthly_revenue` is highly correlated with `product_category_name` and 14 other fields	High correlation
`seller_state` is highly correlated with `geolocation_state` and 3 other fields	High correlation
`customer_state` is highly correlated with `geolocation_state` and 3 other fields	High correlation
`df_index` has unique values	Unique

Reproduction

Analysis started	2021-03-16 09:35:06.610312
Analysis finished	2021-03-16 09:57:37.828281
Duration	22 minutes and 31.22 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	1355602
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	755088.2972
Minimum	0
Maximum	1510941
Zeros	1
Zeros (%)	< 0.1%
Memory size	10.3 MiB

Quantile statistics

Minimum	0
5-th percentile	78459.05
Q1	377174.25
median	754573.5
Q3	1125143.75
95-th percentile	1434011.95
Maximum	1510941
Range	1510941
Interquartile range (IQR)	747969.5

Descriptive statistics

Standard deviation	434484.0444
Coefficient of variation (CV)	0.5754082616
Kurtosis	-1.19718681
Mean	755088.2972
Median Absolute Deviation (MAD)	374125.5
Skewness	0.002141281909
Sum	1.023599206 × 10¹²
Variance	1.887763848 × 10¹¹
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
1289436	1	< 0.1%
1285338	1	< 0.1%
1279193	1	< 0.1%
1281240	1	< 0.1%
1307863	1	< 0.1%
1309910	1	< 0.1%
1303765	1	< 0.1%
1295569	1	< 0.1%
1297616	1	< 0.1%
Other values (1355592)	1355592	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
1510941	1	< 0.1%
1510940	1	< 0.1%
1510939	1	< 0.1%
1510938	1	< 0.1%
1510937	1	< 0.1%

review_id
Categorical

HIGH CARDINALITY

Distinct	4447
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

03129dea7c12fa5878b2e629ccdf2ce6	6860
ee4bc8e340e8648a44c2e33fee6b27e4	6706
6e2e708cf22ce71fc6c89bde34e36a06	5200
101953a8fbbf1cc53809d5615bbf893b	4896
647d8053175e712d435045a22ab48e48	4896
Other values (4442)	1327044

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6f78e9f489a355a65ff8df35a39d3753
2nd row	6f78e9f489a355a65ff8df35a39d3753
3rd row	6f78e9f489a355a65ff8df35a39d3753
4th row	6f78e9f489a355a65ff8df35a39d3753
5th row	6f78e9f489a355a65ff8df35a39d3753

Value	Count	Frequency (%)
03129dea7c12fa5878b2e629ccdf2ce6	6860	0.5%
ee4bc8e340e8648a44c2e33fee6b27e4	6706	0.5%
6e2e708cf22ce71fc6c89bde34e36a06	5200	0.4%
101953a8fbbf1cc53809d5615bbf893b	4896	0.4%
647d8053175e712d435045a22ab48e48	4896	0.4%
6532f3ce8359fe5f1f69a476974556c1	4340	0.3%
c0dd4ca18424520737d855ec6f1c17b0	4048	0.3%
3e2e445b1e2abdce0ff0925681c1806d	4004	0.3%
63f52661d616df41166b2c916db628f6	4004	0.3%
73e75eb3d7ec3e9758f4edc2fe809fdc	3942	0.3%
Other values (4437)	1306706	96.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
03129dea7c12fa5878b2e629ccdf2ce6	6860	0.5%
ee4bc8e340e8648a44c2e33fee6b27e4	6706	0.5%
6e2e708cf22ce71fc6c89bde34e36a06	5200	0.4%
101953a8fbbf1cc53809d5615bbf893b	4896	0.4%
647d8053175e712d435045a22ab48e48	4896	0.4%
6532f3ce8359fe5f1f69a476974556c1	4340	0.3%
c0dd4ca18424520737d855ec6f1c17b0	4048	0.3%
3e2e445b1e2abdce0ff0925681c1806d	4004	0.3%
63f52661d616df41166b2c916db628f6	4004	0.3%
73e75eb3d7ec3e9758f4edc2fe809fdc	3942	0.3%
Other values (4437)	1306706	96.4%

Most occurring characters

Value	Count	Frequency (%)
e	2810100	6.5%
d	2791610	6.4%
c	2775680	6.4%
5	2745273	6.3%
1	2724780	6.3%
b	2724401	6.3%
6	2722970	6.3%
4	2717301	6.3%
8	2716876	6.3%
3	2687421	6.2%
Other values (6)	15962852	36.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26964444	62.2%
Lowercase Letter	16414820	37.8%

Most frequent character per category

Value	Count	Frequency (%)
5	2745273	10.2%
1	2724780	10.1%
6	2722970	10.1%
4	2717301	10.1%
8	2716876	10.1%
3	2687421	10.0%
7	2687171	10.0%
0	2675635	9.9%
2	2665241	9.9%
9	2621776	9.7%

Value	Count	Frequency (%)
e	2810100	17.1%
d	2791610	17.0%
c	2775680	16.9%
b	2724401	16.6%
f	2683048	16.3%
a	2629981	16.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	26964444	62.2%
Latin	16414820	37.8%

Most frequent character per script

Value	Count	Frequency (%)
5	2745273	10.2%
1	2724780	10.1%
6	2722970	10.1%
4	2717301	10.1%
8	2716876	10.1%
3	2687421	10.0%
7	2687171	10.0%
0	2675635	9.9%
2	2665241	9.9%
9	2621776	9.7%

Value	Count	Frequency (%)
e	2810100	17.1%
d	2791610	17.0%
c	2775680	16.9%
b	2724401	16.6%
f	2683048	16.3%
a	2629981	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	2810100	6.5%
d	2791610	6.4%
c	2775680	6.4%
5	2745273	6.3%
1	2724780	6.3%
b	2724401	6.3%
6	2722970	6.3%
4	2717301	6.3%
8	2716876	6.3%
3	2687421	6.2%
Other values (6)	15962852	36.8%

order_id
Categorical

HIGH CARDINALITY

Distinct	4453
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

9bdc4d4c71aa1de4606060929dee888c	6860
73c8ab38f07dc94389065f7eba4f297a	6706
f60ce04ff8060152c83c7c97e246d6a8	5200
6a30ecf6e27a0c6c8373a4ffc57cb353	4896
3200257acc9dd36d1fa819e72fca7e59	4896
Other values (4448)	1327044

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cd07e3ceeebd529181ed30afdf30d43f
2nd row	cd07e3ceeebd529181ed30afdf30d43f
3rd row	cd07e3ceeebd529181ed30afdf30d43f
4th row	cd07e3ceeebd529181ed30afdf30d43f
5th row	cd07e3ceeebd529181ed30afdf30d43f

Value	Count	Frequency (%)
9bdc4d4c71aa1de4606060929dee888c	6860	0.5%
73c8ab38f07dc94389065f7eba4f297a	6706	0.5%
f60ce04ff8060152c83c7c97e246d6a8	5200	0.4%
6a30ecf6e27a0c6c8373a4ffc57cb353	4896	0.4%
3200257acc9dd36d1fa819e72fca7e59	4896	0.4%
cf287f639abd10b1630574c4a065d4f1	4896	0.4%
18f4178d9b3c33fa79c1a0d5eb214023	4340	0.3%
be382a9e1ed25128148b97d6bfdb21af	4048	0.3%
61edec4c7086a5383dc4f5e6fca69e9b	4004	0.3%
3241baf723e29f140a6ff9082b7f9aca	4004	0.3%
Other values (4443)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
9bdc4d4c71aa1de4606060929dee888c	6860	0.5%
73c8ab38f07dc94389065f7eba4f297a	6706	0.5%
f60ce04ff8060152c83c7c97e246d6a8	5200	0.4%
6a30ecf6e27a0c6c8373a4ffc57cb353	4896	0.4%
3200257acc9dd36d1fa819e72fca7e59	4896	0.4%
cf287f639abd10b1630574c4a065d4f1	4896	0.4%
18f4178d9b3c33fa79c1a0d5eb214023	4340	0.3%
be382a9e1ed25128148b97d6bfdb21af	4048	0.3%
61edec4c7086a5383dc4f5e6fca69e9b	4004	0.3%
3241baf723e29f140a6ff9082b7f9aca	4004	0.3%
Other values (4443)	1305752	96.3%

Most occurring characters

Value	Count	Frequency (%)
8	2826922	6.5%
f	2776056	6.4%
7	2761417	6.4%
a	2758546	6.4%
9	2749210	6.3%
3	2742747	6.3%
4	2728055	6.3%
e	2720770	6.3%
c	2719793	6.3%
6	2719214	6.3%
Other values (6)	15876534	36.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27014524	62.3%
Lowercase Letter	16364740	37.7%

Most frequent character per category

Value	Count	Frequency (%)
8	2826922	10.5%
7	2761417	10.2%
9	2749210	10.2%
3	2742747	10.2%
4	2728055	10.1%
6	2719214	10.1%
0	2659271	9.8%
2	2639420	9.8%
5	2610318	9.7%
1	2577950	9.5%

Value	Count	Frequency (%)
f	2776056	17.0%
a	2758546	16.9%
e	2720770	16.6%
c	2719793	16.6%
d	2715202	16.6%
b	2674373	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	27014524	62.3%
Latin	16364740	37.7%

Most frequent character per script

Value	Count	Frequency (%)
8	2826922	10.5%
7	2761417	10.2%
9	2749210	10.2%
3	2742747	10.2%
4	2728055	10.1%
6	2719214	10.1%
0	2659271	9.8%
2	2639420	9.8%
5	2610318	9.7%
1	2577950	9.5%

Value	Count	Frequency (%)
f	2776056	17.0%
a	2758546	16.9%
e	2720770	16.6%
c	2719793	16.6%
d	2715202	16.6%
b	2674373	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
8	2826922	6.5%
f	2776056	6.4%
7	2761417	6.4%
a	2758546	6.4%
9	2749210	6.3%
3	2742747	6.3%
4	2728055	6.3%
e	2720770	6.3%
c	2719793	6.3%
6	2719214	6.3%
Other values (6)	15876534	36.6%

review_score
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

5	791670
4	248565
1	164032
3	115980
2	35355

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1355602
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	5
3rd row	5
4th row	5
5th row	5

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

Most occurring characters

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1355602	100.0%

Most frequent character per category

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	1355602	100.0%

Most frequent character per script

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1355602	100.0%

Most frequent character per block

Value	Count	Frequency (%)
5	791670	58.4%
4	248565	18.3%
1	164032	12.1%
3	115980	8.6%
2	35355	2.6%

review_creation_date
Categorical

HIGH CARDINALITY

Distinct	516
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2017-12-29 00:00:00	12557
2017-12-05 00:00:00	12475
2017-12-19 00:00:00	10914
2018-08-31 00:00:00	10403
2018-03-24 00:00:00	10374
Other values (511)	1298879

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-05-04 00:00:00
2nd row	2017-05-04 00:00:00
3rd row	2017-05-04 00:00:00
4th row	2017-05-04 00:00:00
5th row	2017-05-04 00:00:00

Value	Count	Frequency (%)
2017-12-29 00:00:00	12557	0.9%
2017-12-05 00:00:00	12475	0.9%
2017-12-19 00:00:00	10914	0.8%
2018-08-31 00:00:00	10403	0.8%
2018-03-24 00:00:00	10374	0.8%
2018-08-28 00:00:00	10303	0.8%
2018-05-15 00:00:00	10134	0.7%
2017-11-28 00:00:00	9645	0.7%
2018-03-02 00:00:00	8934	0.7%
2018-05-19 00:00:00	8774	0.6%
Other values (506)	1251089	92.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	1355020	50.0%
2017-12-29	12557	0.5%
2017-12-05	12475	0.5%
2017-12-19	10914	0.4%
2018-08-31	10403	0.4%
2018-03-24	10374	0.4%
2018-08-28	10303	0.4%
2018-05-15	10134	0.4%
2017-11-28	9645	0.4%
2018-03-02	8934	0.3%
Other values (508)	1260445	46.5%

Most occurring characters

Value	Count	Frequency (%)
0	11141906	43.3%
-	2711204	10.5%
:	2711204	10.5%
1	2341255	9.1%
2	2227857	8.6%
	1355602	5.3%
8	1076423	4.2%
7	836964	3.2%
3	323597	1.3%
5	280153	1.1%
Other values (3)	750273	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	11141906	58.7%
1	2341255	12.3%
2	2227857	11.7%
8	1076423	5.7%
7	836964	4.4%
3	323597	1.7%
5	280153	1.5%
4	278207	1.5%
6	269057	1.4%
9	203009	1.1%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	11141906	43.3%
-	2711204	10.5%
:	2711204	10.5%
1	2341255	9.1%
2	2227857	8.6%
	1355602	5.3%
8	1076423	4.2%
7	836964	3.2%
3	323597	1.3%
5	280153	1.1%
Other values (3)	750273	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	11141906	43.3%
-	2711204	10.5%
:	2711204	10.5%
1	2341255	9.1%
2	2227857	8.6%
	1355602	5.3%
8	1076423	4.2%
7	836964	3.2%
3	323597	1.3%
5	280153	1.1%
Other values (3)	750273	2.9%

review_answer_timestamp
Categorical

HIGH CARDINALITY

Distinct	4447
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-03-03 00:44:54	6860
2017-12-31 12:08:24	6706
2017-12-06 00:41:56	5200
2018-02-19 00:00:01	4896
2018-04-01 02:28:01	4896
Other values (4442)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-05-05 19:51:22
2nd row	2017-05-05 19:51:22
3rd row	2017-05-05 19:51:22
4th row	2017-05-05 19:51:22
5th row	2017-05-05 19:51:22

Value	Count	Frequency (%)
2018-03-03 00:44:54	6860	0.5%
2017-12-31 12:08:24	6706	0.5%
2017-12-06 00:41:56	5200	0.4%
2018-02-19 00:00:01	4896	0.4%
2018-04-01 02:28:01	4896	0.4%
2018-05-15 22:41:08	4340	0.3%
2017-11-26 12:37:32	4048	0.3%
2018-06-13 11:37:46	4004	0.3%
2017-08-21 19:25:44	4004	0.3%
2017-11-29 09:46:49	3942	0.3%
Other values (4437)	1306706	96.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-01	13044	0.5%
2017-12-08	13013	0.5%
2018-02-19	9107	0.3%
2018-08-31	9095	0.3%
2017-11-29	8700	0.3%
2017-08-02	8672	0.3%
2017-12-11	8648	0.3%
2017-12-31	8637	0.3%
2018-05-21	8051	0.3%
2018-03-03	8033	0.3%
Other values (4883)	2616204	96.5%

Most occurring characters

Value	Count	Frequency (%)
0	4355175	16.9%
1	4025212	15.6%
2	3435858	13.3%
-	2711204	10.5%
:	2711204	10.5%
8	1397261	5.4%
	1355602	5.3%
3	1255115	4.9%
7	1138316	4.4%
5	1098048	4.3%
Other values (3)	2273443	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	4355175	22.9%
1	4025212	21.2%
2	3435858	18.1%
8	1397261	7.4%
3	1255115	6.6%
7	1138316	6.0%
5	1098048	5.8%
4	1081885	5.7%
6	637036	3.4%
9	554522	2.9%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4355175	16.9%
1	4025212	15.6%
2	3435858	13.3%
-	2711204	10.5%
:	2711204	10.5%
8	1397261	5.4%
	1355602	5.3%
3	1255115	4.9%
7	1138316	4.4%
5	1098048	4.3%
Other values (3)	2273443	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4355175	16.9%
1	4025212	15.6%
2	3435858	13.3%
-	2711204	10.5%
:	2711204	10.5%
8	1397261	5.4%
	1355602	5.3%
3	1255115	4.9%
7	1138316	4.4%
5	1098048	4.3%
Other values (3)	2273443	8.8%

customer_id
Categorical

HIGH CARDINALITY

Distinct	4453
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

a7693fba2ff9583c78751f2b66ecab9d	6860
d5f2b3f597c7ccafbb5cac0bcc3d6024	6706
78fc46047c4a639e81ff65f0396e02fe	5200
c8a84c4b2aea91e2cfd48a87ae2a8947	4896
a193aa8d905b8e2460a1f49e26caa4a9	4896
Other values (4448)	1327044

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3c96cfdac2bce85bd05840b62c0e2e8e
2nd row	3c96cfdac2bce85bd05840b62c0e2e8e
3rd row	3c96cfdac2bce85bd05840b62c0e2e8e
4th row	3c96cfdac2bce85bd05840b62c0e2e8e
5th row	3c96cfdac2bce85bd05840b62c0e2e8e

Value	Count	Frequency (%)
a7693fba2ff9583c78751f2b66ecab9d	6860	0.5%
d5f2b3f597c7ccafbb5cac0bcc3d6024	6706	0.5%
78fc46047c4a639e81ff65f0396e02fe	5200	0.4%
c8a84c4b2aea91e2cfd48a87ae2a8947	4896	0.4%
a193aa8d905b8e2460a1f49e26caa4a9	4896	0.4%
baa22cca29768548ef9cea07cf105737	4896	0.4%
1f68e24da06f36cb8a5243e23c390bcf	4340	0.3%
0c792d32a3251b4f69dae8646dfbedbc	4048	0.3%
3e13d7562141418f00f431202390536c	4004	0.3%
395ce4e9b5ad9165113d5321fcb7a864	4004	0.3%
Other values (4443)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
a7693fba2ff9583c78751f2b66ecab9d	6860	0.5%
d5f2b3f597c7ccafbb5cac0bcc3d6024	6706	0.5%
78fc46047c4a639e81ff65f0396e02fe	5200	0.4%
c8a84c4b2aea91e2cfd48a87ae2a8947	4896	0.4%
a193aa8d905b8e2460a1f49e26caa4a9	4896	0.4%
baa22cca29768548ef9cea07cf105737	4896	0.4%
1f68e24da06f36cb8a5243e23c390bcf	4340	0.3%
0c792d32a3251b4f69dae8646dfbedbc	4048	0.3%
3e13d7562141418f00f431202390536c	4004	0.3%
395ce4e9b5ad9165113d5321fcb7a864	4004	0.3%
Other values (4443)	1305752	96.3%

Most occurring characters

Value	Count	Frequency (%)
f	2770363	6.4%
a	2762632	6.4%
6	2761626	6.4%
c	2742849	6.3%
8	2739607	6.3%
9	2737291	6.3%
5	2722130	6.3%
1	2703052	6.2%
7	2699600	6.2%
e	2698715	6.2%
Other values (6)	16041399	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27068001	62.4%
Lowercase Letter	16311263	37.6%

Most frequent character per category

Value	Count	Frequency (%)
6	2761626	10.2%
8	2739607	10.1%
9	2737291	10.1%
5	2722130	10.1%
1	2703052	10.0%
7	2699600	10.0%
4	2691350	9.9%
0	2679661	9.9%
2	2676374	9.9%
3	2657310	9.8%

Value	Count	Frequency (%)
f	2770363	17.0%
a	2762632	16.9%
c	2742849	16.8%
e	2698715	16.5%
b	2676058	16.4%
d	2660646	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	27068001	62.4%
Latin	16311263	37.6%

Most frequent character per script

Value	Count	Frequency (%)
6	2761626	10.2%
8	2739607	10.1%
9	2737291	10.1%
5	2722130	10.1%
1	2703052	10.0%
7	2699600	10.0%
4	2691350	9.9%
0	2679661	9.9%
2	2676374	9.9%
3	2657310	9.8%

Value	Count	Frequency (%)
f	2770363	17.0%
a	2762632	16.9%
c	2742849	16.8%
e	2698715	16.5%
b	2676058	16.4%
d	2660646	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
f	2770363	6.4%
a	2762632	6.4%
6	2761626	6.4%
c	2742849	6.3%
8	2739607	6.3%
9	2737291	6.3%
5	2722130	6.3%
1	2703052	6.2%
7	2699600	6.2%
e	2698715	6.2%
Other values (6)	16041399	37.0%

order_status
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

delivered	1355602

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	12200418
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Value	Count	Frequency (%)
delivered	1355602	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
delivered	1355602	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	4066806	33.3%
d	2711204	22.2%
l	1355602	11.1%
i	1355602	11.1%
v	1355602	11.1%
r	1355602	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12200418	100.0%

Most frequent character per category

Value	Count	Frequency (%)
e	4066806	33.3%
d	2711204	22.2%
l	1355602	11.1%
i	1355602	11.1%
v	1355602	11.1%
r	1355602	11.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12200418	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	4066806	33.3%
d	2711204	22.2%
l	1355602	11.1%
i	1355602	11.1%
v	1355602	11.1%
r	1355602	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12200418	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	4066806	33.3%
d	2711204	22.2%
l	1355602	11.1%
i	1355602	11.1%
v	1355602	11.1%
r	1355602	11.1%

order_purchase_timestamp
Categorical

HIGH CARDINALITY

Distinct	4441
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-02-21 11:45:07	6860
2017-12-13 14:21:15	6706
2017-11-28 22:24:18	5200
2018-02-12 18:04:28	4896
2017-11-24 12:58:53	4896
Other values (4436)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-04-21 16:37:49
2nd row	2017-04-21 16:37:49
3rd row	2017-04-21 16:37:49
4th row	2017-04-21 16:37:49
5th row	2017-04-21 16:37:49

Value	Count	Frequency (%)
2018-02-21 11:45:07	6860	0.5%
2017-12-13 14:21:15	6706	0.5%
2017-11-28 22:24:18	5200	0.4%
2018-02-12 18:04:28	4896	0.4%
2017-11-24 12:58:53	4896	0.4%
2018-03-25 14:29:45	4896	0.4%
2018-05-07 19:12:47	4340	0.3%
2017-11-04 17:29:15	4048	0.3%
2017-08-02 12:57:27	4004	0.3%
2018-06-06 15:11:41	4004	0.3%
Other values (4431)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	24513	0.9%
2018-02-12	9226	0.3%
2018-02-21	8743	0.3%
2017-11-28	8556	0.3%
2018-03-25	8437	0.3%
2017-11-26	8217	0.3%
2017-12-13	7996	0.3%
2018-03-26	7333	0.3%
2018-05-02	7289	0.3%
2017-11-25	7226	0.3%
Other values (4881)	2613668	96.4%

Most occurring characters

Value	Count	Frequency (%)
1	4245856	16.5%
0	4112655	16.0%
2	3381076	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1410641	5.5%
	1355602	5.3%
7	1256160	4.9%
3	1148344	4.5%
5	1100203	4.3%
Other values (3)	2323493	9.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
1	4245856	22.4%
0	4112655	21.7%
2	3381076	17.8%
8	1410641	7.4%
7	1256160	6.6%
3	1148344	6.1%
5	1100203	5.8%
4	1097614	5.8%
6	658039	3.5%
9	567840	3.0%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	4245856	16.5%
0	4112655	16.0%
2	3381076	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1410641	5.5%
	1355602	5.3%
7	1256160	4.9%
3	1148344	4.5%
5	1100203	4.3%
Other values (3)	2323493	9.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	4245856	16.5%
0	4112655	16.0%
2	3381076	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1410641	5.5%
	1355602	5.3%
7	1256160	4.9%
3	1148344	4.5%
5	1100203	4.3%
Other values (3)	2323493	9.0%

order_approved_at
Categorical

HIGH CARDINALITY

Distinct	4428
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-02-22 11:48:42	6860
2017-12-15 02:30:41	6706
2017-11-28 22:31:34	5200
2017-11-24 15:13:44	4896
2018-02-12 18:10:32	4896
Other values (4423)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-04-21 16:50:18
2nd row	2017-04-21 16:50:18
3rd row	2017-04-21 16:50:18
4th row	2017-04-21 16:50:18
5th row	2017-04-21 16:50:18

Value	Count	Frequency (%)
2018-02-22 11:48:42	6860	0.5%
2017-12-15 02:30:41	6706	0.5%
2017-11-28 22:31:34	5200	0.4%
2017-11-24 15:13:44	4896	0.4%
2018-02-12 18:10:32	4896	0.4%
2018-03-25 14:48:01	4896	0.4%
2018-05-07 19:30:08	4340	0.3%
2017-11-07 16:31:17	4048	0.3%
2017-08-02 13:10:10	4004	0.3%
2018-06-06 15:34:23	4004	0.3%
Other values (4418)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	19456	0.7%
2018-04-24	14578	0.5%
2018-02-22	13596	0.5%
2017-11-25	10409	0.4%
2017-11-28	10329	0.4%
2018-05-07	10181	0.4%
2018-07-05	9136	0.3%
2018-04-10	8773	0.3%
2017-12-15	8753	0.3%
2018-02-12	7901	0.3%
Other values (4645)	2598092	95.8%

Most occurring characters

Value	Count	Frequency (%)
0	4344463	16.9%
1	4187221	16.3%
2	3357970	13.0%
-	2711204	10.5%
:	2711204	10.5%
8	1359153	5.3%
	1355602	5.3%
5	1281655	5.0%
3	1227669	4.8%
7	1180395	4.6%
Other values (3)	2039902	7.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	4344463	22.9%
1	4187221	22.1%
2	3357970	17.7%
8	1359153	7.2%
5	1281655	6.8%
3	1227669	6.5%
7	1180395	6.2%
4	971587	5.1%
6	563665	3.0%
9	504650	2.7%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4344463	16.9%
1	4187221	16.3%
2	3357970	13.0%
-	2711204	10.5%
:	2711204	10.5%
8	1359153	5.3%
	1355602	5.3%
5	1281655	5.0%
3	1227669	4.8%
7	1180395	4.6%
Other values (3)	2039902	7.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4344463	16.9%
1	4187221	16.3%
2	3357970	13.0%
-	2711204	10.5%
:	2711204	10.5%
8	1359153	5.3%
	1355602	5.3%
5	1281655	5.0%
3	1227669	4.8%
7	1180395	4.6%
Other values (3)	2039902	7.9%

order_delivered_carrier_date
Categorical

HIGH CARDINALITY

Distinct	4393
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-02-27 18:27:01	6860
2017-12-15 18:45:18	6706
2017-11-29 19:48:33	5200
2018-03-26 23:48:46	4896
2018-02-14 22:58:48	4896
Other values (4388)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-04-24 17:44:09
2nd row	2017-04-24 17:44:09
3rd row	2017-04-24 17:44:09
4th row	2017-04-24 17:44:09
5th row	2017-04-24 17:44:09

Value	Count	Frequency (%)
2018-02-27 18:27:01	6860	0.5%
2017-12-15 18:45:18	6706	0.5%
2017-11-29 19:48:33	5200	0.4%
2018-03-26 23:48:46	4896	0.4%
2018-02-14 22:58:48	4896	0.4%
2017-11-28 15:29:05	4896	0.4%
2018-05-08 14:41:00	4340	0.3%
2017-11-21 14:22:28	4048	0.3%
2018-06-07 12:20:00	4004	0.3%
2017-08-04 17:05:52	4004	0.3%
Other values (4383)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-28	14589	0.5%
2018-02-27	13278	0.5%
2017-11-29	12949	0.5%
2018-05-08	12854	0.5%
2018-01-23	11341	0.4%
2018-03-26	10388	0.4%
2018-03-20	9756	0.4%
2017-12-11	9751	0.4%
2017-12-01	9545	0.4%
2018-08-20	8860	0.3%
Other values (3957)	2597893	95.8%

Most occurring characters

Value	Count	Frequency (%)
0	4639863	18.0%
1	3993591	15.5%
2	3283230	12.7%
-	2711204	10.5%
:	2711204	10.5%
8	1466072	5.7%
	1355602	5.3%
7	1237612	4.8%
3	1097428	4.3%
4	1063806	4.1%
Other values (3)	2196826	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	4639863	24.4%
1	3993591	21.0%
2	3283230	17.3%
8	1466072	7.7%
7	1237612	6.5%
3	1097428	5.8%
4	1063806	5.6%
5	1053206	5.5%
9	574097	3.0%
6	569523	3.0%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4639863	18.0%
1	3993591	15.5%
2	3283230	12.7%
-	2711204	10.5%
:	2711204	10.5%
8	1466072	5.7%
	1355602	5.3%
7	1237612	4.8%
3	1097428	4.3%
4	1063806	4.1%
Other values (3)	2196826	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4639863	18.0%
1	3993591	15.5%
2	3283230	12.7%
-	2711204	10.5%
:	2711204	10.5%
8	1466072	5.7%
	1355602	5.3%
7	1237612	4.8%
3	1097428	4.3%
4	1063806	4.1%
Other values (3)	2196826	8.5%

order_delivered_customer_date
Categorical

HIGH CARDINALITY

Distinct	4450
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-03-01 20:47:01	6860
2017-12-28 09:05:34	6706
2017-12-04 22:22:20	5200
2017-12-04 20:33:01	4896
2018-03-30 19:28:53	4896
Other values (4445)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-05-03 14:32:54
2nd row	2017-05-03 14:32:54
3rd row	2017-05-03 14:32:54
4th row	2017-05-03 14:32:54
5th row	2017-05-03 14:32:54

Value	Count	Frequency (%)
2018-03-01 20:47:01	6860	0.5%
2017-12-28 09:05:34	6706	0.5%
2017-12-04 22:22:20	5200	0.4%
2017-12-04 20:33:01	4896	0.4%
2018-03-30 19:28:53	4896	0.4%
2018-02-16 22:32:51	4896	0.4%
2018-05-14 16:48:43	4340	0.3%
2017-11-23 20:28:46	4048	0.3%
2017-08-14 19:36:59	4004	0.3%
2018-06-11 22:11:14	4004	0.3%
Other values (4440)	1305752	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-12-04	13699	0.5%
2017-12-28	13125	0.5%
2018-03-23	11331	0.4%
2018-03-01	10884	0.4%
2018-08-30	10492	0.4%
2018-08-27	10179	0.4%
2017-11-27	9679	0.4%
2018-05-14	9631	0.4%
2018-03-29	8803	0.3%
2017-06-19	8526	0.3%
Other values (4692)	2604855	96.1%

Most occurring characters

Value	Count	Frequency (%)
0	3959545	15.4%
1	3938351	15.3%
2	3487113	13.5%
-	2711204	10.5%
:	2711204	10.5%
8	1594312	6.2%
	1355602	5.3%
3	1268274	4.9%
7	1244552	4.8%
4	1185315	4.6%
Other values (3)	2300966	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	3959545	20.9%
1	3938351	20.8%
2	3487113	18.4%
8	1594312	8.4%
3	1268274	6.7%
7	1244552	6.6%
4	1185315	6.2%
5	1059017	5.6%
6	677180	3.6%
9	564769	3.0%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	3959545	15.4%
1	3938351	15.3%
2	3487113	13.5%
-	2711204	10.5%
:	2711204	10.5%
8	1594312	6.2%
	1355602	5.3%
3	1268274	4.9%
7	1244552	4.8%
4	1185315	4.6%
Other values (3)	2300966	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3959545	15.4%
1	3938351	15.3%
2	3487113	13.5%
-	2711204	10.5%
:	2711204	10.5%
8	1594312	6.2%
	1355602	5.3%
3	1268274	4.9%
7	1244552	4.8%
4	1185315	4.6%
Other values (3)	2300966	8.9%

order_estimated_delivery_date
Categorical

HIGH CARDINALITY

Distinct	402
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2017-12-18 00:00:00	13447
2017-12-27 00:00:00	12821
2018-03-07 00:00:00	12557
2018-04-05 00:00:00	12457
2018-02-09 00:00:00	11058
Other values (397)	1293262

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-05-23 00:00:00
2nd row	2017-05-23 00:00:00
3rd row	2017-05-23 00:00:00
4th row	2017-05-23 00:00:00
5th row	2017-05-23 00:00:00

Value	Count	Frequency (%)
2017-12-18 00:00:00	13447	1.0%
2017-12-27 00:00:00	12821	0.9%
2018-03-07 00:00:00	12557	0.9%
2018-04-05 00:00:00	12457	0.9%
2018-02-09 00:00:00	11058	0.8%
2018-07-12 00:00:00	10933	0.8%
2017-12-20 00:00:00	10193	0.8%
2018-04-20 00:00:00	9964	0.7%
2018-07-27 00:00:00	9869	0.7%
2018-01-08 00:00:00	9496	0.7%
Other values (392)	1242807	91.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	1355602	50.0%
2017-12-18	13447	0.5%
2017-12-27	12821	0.5%
2018-03-07	12557	0.5%
2018-04-05	12457	0.5%
2018-02-09	11058	0.4%
2018-07-12	10933	0.4%
2017-12-20	10193	0.4%
2018-04-20	9964	0.4%
2018-07-27	9869	0.4%
Other values (393)	1252303	46.2%

Most occurring characters

Value	Count	Frequency (%)
0	11222470	43.6%
-	2711204	10.5%
:	2711204	10.5%
1	2307097	9.0%
2	2115049	8.2%
	1355602	5.3%
8	1110354	4.3%
7	846508	3.3%
3	353890	1.4%
5	292293	1.1%
Other values (3)	730767	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	11222470	59.1%
1	2307097	12.2%
2	2115049	11.1%
8	1110354	5.9%
7	846508	4.5%
3	353890	1.9%
5	292293	1.5%
4	257128	1.4%
6	247836	1.3%
9	225803	1.2%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	11222470	43.6%
-	2711204	10.5%
:	2711204	10.5%
1	2307097	9.0%
2	2115049	8.2%
	1355602	5.3%
8	1110354	4.3%
7	846508	3.3%
3	353890	1.4%
5	292293	1.1%
Other values (3)	730767	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	11222470	43.6%
-	2711204	10.5%
:	2711204	10.5%
1	2307097	9.0%
2	2115049	8.2%
	1355602	5.3%
8	1110354	4.3%
7	846508	3.3%
3	353890	1.4%
5	292293	1.1%
Other values (3)	730767	2.8%

payment_sequential
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.066447232
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.422129206
Coefficient of variation (CV)	0.3958275604
Kurtosis	126.7325389
Mean	1.066447232
Median Absolute Deviation (MAD)	0
Skewness	9.970571974
Sum	1445678
Variance	0.1781930665
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	1301470	96.0%
2	38191	2.8%
3	7493	0.6%
4	3331	0.2%
5	1721	0.1%
6	1668	0.1%
7	852	0.1%
8	438	< 0.1%
9	438	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1301470	96.0%
2	38191	2.8%
3	7493	0.6%
4	3331	0.2%
5	1721	0.1%

Value	Count	Frequency (%)
9	438	< 0.1%
8	438	< 0.1%
7	852	0.1%
6	1668	0.1%
5	1721	0.1%

payment_type
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

credit_card	986770
boleto	287254
voucher	66563
debit_card	15015

Length

Max length	11
Median length	11
Mean length	9.733007918
Min length	6

Characters and Unicode

Total characters	13194085
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	credit_card
3rd row	credit_card
4th row	credit_card
5th row	credit_card

Value	Count	Frequency (%)
credit_card	986770	72.8%
boleto	287254	21.2%
voucher	66563	4.9%
debit_card	15015	1.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
credit_card	986770	72.8%
boleto	287254	21.2%
voucher	66563	4.9%
debit_card	15015	1.1%

Most occurring characters

Value	Count	Frequency (%)
c	2055118	15.6%
r	2055118	15.6%
d	2003570	15.2%
e	1355602	10.3%
t	1289039	9.8%
i	1001785	7.6%
_	1001785	7.6%
a	1001785	7.6%
o	641071	4.9%
b	302269	2.3%
Other values (4)	486943	3.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12192300	92.4%
Connector Punctuation	1001785	7.6%

Most frequent character per category

Value	Count	Frequency (%)
c	2055118	16.9%
r	2055118	16.9%
d	2003570	16.4%
e	1355602	11.1%
t	1289039	10.6%
i	1001785	8.2%
a	1001785	8.2%
o	641071	5.3%
b	302269	2.5%
l	287254	2.4%
Other values (3)	199689	1.6%

Value	Count	Frequency (%)
_	1001785	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12192300	92.4%
Common	1001785	7.6%

Most frequent character per script

Value	Count	Frequency (%)
c	2055118	16.9%
r	2055118	16.9%
d	2003570	16.4%
e	1355602	11.1%
t	1289039	10.6%
i	1001785	8.2%
a	1001785	8.2%
o	641071	5.3%
b	302269	2.5%
l	287254	2.4%
Other values (3)	199689	1.6%

Value	Count	Frequency (%)
_	1001785	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13194085	100.0%

Most frequent character per block

Value	Count	Frequency (%)
c	2055118	15.6%
r	2055118	15.6%
d	2003570	15.2%
e	1355602	10.3%
t	1289039	9.8%
i	1001785	7.6%
_	1001785	7.6%
a	1001785	7.6%
o	641071	4.9%
b	302269	2.3%
Other values (4)	486943	3.7%

payment_installments
Real number (ℝ_≥0)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.949155431
Minimum	1
Maximum	24
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	10
Maximum	24
Range	23
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.011912449
Coefficient of variation (CV)	1.021279658
Kurtosis	9.446204621
Mean	2.949155431
Median Absolute Deviation (MAD)	0
Skewness	2.424979143
Sum	3997881
Variance	9.071616603
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	699202	51.6%
2	145613	10.7%
3	125435	9.3%
4	86864	6.4%
5	82826	6.1%
10	76917	5.7%
6	51274	3.8%
8	45401	3.3%
7	26132	1.9%
9	5766	0.4%
Other values (7)	10172	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	699202	51.6%
2	145613	10.7%
3	125435	9.3%
4	86864	6.4%
5	82826	6.1%

Value	Count	Frequency (%)
24	5200	0.4%
20	520	< 0.1%
18	701	0.1%
15	906	0.1%
14	204	< 0.1%

payment_value
Real number (ℝ_≥0)

Distinct	3677
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	178.9453111
Minimum	0.03
Maximum	3666.42
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	0.03
5-th percentile	25.88
Q1	60
median	111.58
Q3	194
95-th percentile	547.96
Maximum	3666.42
Range	3666.39
Interquartile range (IQR)	134

Descriptive statistics

Standard deviation	245.3296562
Coefficient of variation (CV)	1.370975605
Kurtosis	31.20581507
Mean	178.9453111
Median Absolute Deviation (MAD)	60.77
Skewness	4.721957009
Sum	242578621.6
Variance	60186.6402
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
528.78	6860	0.5%
1014.02	6706	0.5%
1440.1	5200	0.4%
333.36	4896	0.4%
536.52	4896	0.4%
305.89	4340	0.3%
50	4188	0.3%
6	4080	0.3%
2039.2	4048	0.3%
392.62	4004	0.3%
Other values (3667)	1306384	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03	200	< 0.1%
0.23	965	0.1%
0.33	408	< 0.1%
0.59	143	< 0.1%
0.74	217	< 0.1%

Value	Count	Frequency (%)
3666.42	186	< 0.1%
3005.06	272	< 0.1%
2455.12	64	< 0.1%
2322.32	128	< 0.1%
2264.9	506	< 0.1%

order_item_id
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.297953234
Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	14
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.078089869
Coefficient of variation (CV)	0.8306076372
Kurtosis	50.76120715
Mean	1.297953234
Median Absolute Deviation (MAD)	0
Skewness	6.322318931
Sum	1759508
Variance	1.162277765
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
1	1159171	85.5%
2	124627	9.2%
3	29641	2.2%
4	15882	1.2%
5	7078	0.5%
6	5584	0.4%
7	3021	0.2%
8	2722	0.2%
9	2073	0.2%
10	1635	0.1%
Other values (4)	4168	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1159171	85.5%
2	124627	9.2%
3	29641	2.2%
4	15882	1.2%
5	7078	0.5%

Value	Count	Frequency (%)
14	969	0.1%
13	969	0.1%
12	1115	0.1%
11	1115	0.1%
10	1635	0.1%

product_id
Categorical

HIGH CARDINALITY

Distinct	3481
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

422879e10f46682990de24d770e7f83d	10692
44a5d24dd383324a421569ca697b13c2	6860
cec09725da5ed01471d9a505e7389d37	6551
389d119b48cf3043d311335e499d9c6b	6542
167b4b8c4bd0c401bea62f5e050d70a4	6363
Other values (3476)	1318594

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	be0dbdc3d67d55727a65d4cd696ca73c
2nd row	be0dbdc3d67d55727a65d4cd696ca73c
3rd row	be0dbdc3d67d55727a65d4cd696ca73c
4th row	be0dbdc3d67d55727a65d4cd696ca73c
5th row	be0dbdc3d67d55727a65d4cd696ca73c

Value	Count	Frequency (%)
422879e10f46682990de24d770e7f83d	10692	0.8%
44a5d24dd383324a421569ca697b13c2	6860	0.5%
cec09725da5ed01471d9a505e7389d37	6551	0.5%
389d119b48cf3043d311335e499d9c6b	6542	0.5%
167b4b8c4bd0c401bea62f5e050d70a4	6363	0.5%
368c6c730842d78016ad823897a372db	6225	0.5%
99a4788cb24856965c36a24e339b6058	5404	0.4%
165f86fe8b799a708a20ee4ba125c289	5352	0.4%
dd8e3ce8409dea51c566f227a4fc34ba	4896	0.4%
aca2eb7d00ea1a7b8ebd4e68314663af	4561	0.3%
Other values (3471)	1292156	95.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
422879e10f46682990de24d770e7f83d	10692	0.8%
44a5d24dd383324a421569ca697b13c2	6860	0.5%
cec09725da5ed01471d9a505e7389d37	6551	0.5%
389d119b48cf3043d311335e499d9c6b	6542	0.5%
167b4b8c4bd0c401bea62f5e050d70a4	6363	0.5%
368c6c730842d78016ad823897a372db	6225	0.5%
99a4788cb24856965c36a24e339b6058	5404	0.4%
165f86fe8b799a708a20ee4ba125c289	5352	0.4%
dd8e3ce8409dea51c566f227a4fc34ba	4896	0.4%
aca2eb7d00ea1a7b8ebd4e68314663af	4561	0.3%
Other values (3471)	1292156	95.3%

Most occurring characters

Value	Count	Frequency (%)
4	2795639	6.4%
3	2773388	6.4%
c	2762014	6.4%
8	2751002	6.3%
a	2744764	6.3%
0	2739763	6.3%
7	2732068	6.3%
e	2722694	6.3%
2	2714217	6.3%
6	2711177	6.2%
Other values (6)	15932538	36.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27219356	62.7%
Lowercase Letter	16159908	37.3%

Most frequent character per category

Value	Count	Frequency (%)
4	2795639	10.3%
3	2773388	10.2%
8	2751002	10.1%
0	2739763	10.1%
7	2732068	10.0%
2	2714217	10.0%
6	2711177	10.0%
9	2696143	9.9%
1	2656787	9.8%
5	2649172	9.7%

Value	Count	Frequency (%)
c	2762014	17.1%
a	2744764	17.0%
e	2722694	16.8%
d	2704210	16.7%
b	2655153	16.4%
f	2571073	15.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	27219356	62.7%
Latin	16159908	37.3%

Most frequent character per script

Value	Count	Frequency (%)
4	2795639	10.3%
3	2773388	10.2%
8	2751002	10.1%
0	2739763	10.1%
7	2732068	10.0%
2	2714217	10.0%
6	2711177	10.0%
9	2696143	9.9%
1	2656787	9.8%
5	2649172	9.7%

Value	Count	Frequency (%)
c	2762014	17.1%
a	2744764	17.0%
e	2722694	16.8%
d	2704210	16.7%
b	2655153	16.4%
f	2571073	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
4	2795639	6.4%
3	2773388	6.4%
c	2762014	6.4%
8	2751002	6.3%
a	2744764	6.3%
0	2739763	6.3%
7	2732068	6.3%
e	2722694	6.3%
2	2714217	6.3%
6	2711177	6.2%
Other values (6)	15932538	36.7%

shipping_limit_date
Categorical

HIGH CARDINALITY

Distinct	4446
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-02-28 11:48:12	6860
2017-12-21 02:30:41	6706
2017-12-04 22:31:28	5200
2018-02-16 18:10:32	4896
2017-12-11 15:13:44	4896
Other values (4441)	1327044

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-04-27 16:50:18
2nd row	2017-04-27 16:50:18
3rd row	2017-04-27 16:50:18
4th row	2017-04-27 16:50:18
5th row	2017-04-27 16:50:18

Value	Count	Frequency (%)
2018-02-28 11:48:12	6860	0.5%
2017-12-21 02:30:41	6706	0.5%
2017-12-04 22:31:28	5200	0.4%
2018-02-16 18:10:32	4896	0.4%
2017-12-11 15:13:44	4896	0.4%
2018-03-29 14:48:01	4896	0.4%
2017-11-21 16:30:47	4048	0.3%
2017-08-08 13:10:10	4004	0.3%
2018-06-14 15:30:52	4004	0.3%
2018-03-25 22:55:28	3942	0.3%
Other values (4436)	1306150	96.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-30	21712	0.8%
2018-02-28	15961	0.6%
2017-12-21	12833	0.5%
2017-12-07	12456	0.5%
2018-05-10	11284	0.4%
2018-03-22	11192	0.4%
2017-12-11	10920	0.4%
2017-12-04	10520	0.4%
2018-03-29	10158	0.4%
2018-03-08	10122	0.4%
Other values (4546)	2584046	95.3%

Most occurring characters

Value	Count	Frequency (%)
0	4347492	16.9%
1	4173960	16.2%
2	3379482	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1417194	5.5%
	1355602	5.3%
3	1298109	5.0%
5	1237121	4.8%
7	1137820	4.4%
Other values (3)	1987250	7.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	4347492	22.9%
1	4173960	22.0%
2	3379482	17.8%
8	1417194	7.5%
3	1298109	6.8%
5	1237121	6.5%
7	1137820	6.0%
4	919850	4.8%
6	535390	2.8%
9	532010	2.8%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4347492	16.9%
1	4173960	16.2%
2	3379482	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1417194	5.5%
	1355602	5.3%
3	1298109	5.0%
5	1237121	4.8%
7	1137820	4.4%
Other values (3)	1987250	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4347492	16.9%
1	4173960	16.2%
2	3379482	13.1%
-	2711204	10.5%
:	2711204	10.5%
8	1417194	5.5%
	1355602	5.3%
3	1298109	5.0%
5	1237121	4.8%
7	1137820	4.4%
Other values (3)	1987250	7.7%

price
Real number (ℝ_≥0)

Distinct	1264
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	113.9570513
Minimum	3.85
Maximum	2699
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	3.85
5-th percentile	16.49
Q1	39.9
median	69.98
Q3	129.9
95-th percentile	320
Maximum	2699
Range	2695.15
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	162.8143505
Coefficient of variation (CV)	1.428734322
Kurtosis	61.52966711
Mean	113.9570513
Median Absolute Deviation (MAD)	39.99
Skewness	6.48077634
Sum	154480406.7
Variance	26508.51272
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69.9	35152	2.6%
59.9	34823	2.6%
49.9	25769	1.9%
99.9	20468	1.5%
29.99	18096	1.3%
89.9	16706	1.2%
59	16641	1.2%
29.9	15756	1.2%
119.9	13531	1.0%
39	12462	0.9%
Other values (1254)	1146198	84.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.85	488	< 0.1%
4.2	2448	0.2%
5.35	572	< 0.1%
5.9	162	< 0.1%
6.12	1794	0.1%

Value	Count	Frequency (%)
2699	272	< 0.1%
2350	64	< 0.1%
2258	128	< 0.1%
2110	911	0.1%
1999.99	202	< 0.1%

freight_value
Real number (ℝ_≥0)

Distinct	1651
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.9232295
Minimum	0
Maximum	306.06
Zeros	1477
Zeros (%)	0.1%
Memory size	10.3 MiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	12.48
median	15.3
Q3	18.72
95-th percentile	38.04
Maximum	306.06
Range	306.06
Interquartile range (IQR)	6.24

Descriptive statistics

Standard deviation	13.05048359
Coefficient of variation (CV)	0.7281323711
Kurtosis	75.89894667
Mean	17.9232295
Median Absolute Deviation (MAD)	3.19
Skewness	6.160223598
Sum	24296765.75
Variance	170.3151219
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.78	45834	3.4%
11.85	34256	2.5%
15.1	30924	2.3%
14.1	26102	1.9%
18.23	17828	1.3%
12.79	14920	1.1%
16.11	14080	1.0%
7.39	12400	0.9%
8.72	12223	0.9%
14.52	11603	0.9%
Other values (1641)	1135432	83.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1477	0.1%
0.14	218	< 0.1%
0.97	206	< 0.1%
0.99	146	< 0.1%
1.08	168	< 0.1%

Value	Count	Frequency (%)
306.06	272	< 0.1%
224.34	96	< 0.1%
187.43	246	< 0.1%
154.9	506	< 0.1%
149.01	96	< 0.1%

product_category_name
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	66
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

cama_mesa_banho	152147
esporte_lazer	115908
beleza_saude	112514
moveis_decoracao	103825
informatica_acessorios	97410
Other values (61)	773798

Length

Max length	46
Median length	15
Mean length	14.86230472
Min length	3

Characters and Unicode

Total characters	20147370
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	informatica_acessorios
2nd row	informatica_acessorios
3rd row	informatica_acessorios
4th row	informatica_acessorios
5th row	informatica_acessorios

Value	Count	Frequency (%)
cama_mesa_banho	152147	11.2%
esporte_lazer	115908	8.6%
beleza_saude	112514	8.3%
moveis_decoracao	103825	7.7%
informatica_acessorios	97410	7.2%
utilidades_domesticas	94041	6.9%
relogios_presentes	65743	4.8%
ferramentas_jardim	61651	4.5%
automotivo	55582	4.1%
brinquedos	51767	3.8%
Other values (56)	445014	32.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
cama_mesa_banho	152147	11.2%
esporte_lazer	115908	8.6%
beleza_saude	112514	8.3%
moveis_decoracao	103825	7.7%
informatica_acessorios	97410	7.2%
utilidades_domesticas	94041	6.9%
relogios_presentes	65743	4.8%
ferramentas_jardim	61651	4.5%
automotivo	55582	4.1%
brinquedos	51767	3.8%
Other values (56)	445014	32.8%

Most occurring characters

Value	Count	Frequency (%)
a	2487458	12.3%
e	2412183	12.0%
s	1973460	9.8%
o	1956003	9.7%
i	1356677	6.7%
r	1319133	6.5%
_	1275345	6.3%
m	970561	4.8%
t	968320	4.8%
c	938962	4.7%
Other values (18)	4489268	22.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18869891	93.7%
Connector Punctuation	1275345	6.3%
Decimal Number	2134	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	2487458	13.2%
e	2412183	12.8%
s	1973460	10.5%
o	1956003	10.4%
i	1356677	7.2%
r	1319133	7.0%
m	970561	5.1%
t	968320	5.1%
c	938962	5.0%
l	670920	3.6%
Other values (16)	3816214	20.2%

Value	Count	Frequency (%)
_	1275345	100.0%

Value	Count	Frequency (%)
2	2134	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18869891	93.7%
Common	1277479	6.3%

Most frequent character per script

Value	Count	Frequency (%)
a	2487458	13.2%
e	2412183	12.8%
s	1973460	10.5%
o	1956003	10.4%
i	1356677	7.2%
r	1319133	7.0%
m	970561	5.1%
t	968320	5.1%
c	938962	5.0%
l	670920	3.6%
Other values (16)	3816214	20.2%

Value	Count	Frequency (%)
_	1275345	99.8%
2	2134	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20147370	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	2487458	12.3%
e	2412183	12.0%
s	1973460	9.8%
o	1956003	9.7%
i	1356677	6.7%
r	1319133	6.5%
_	1275345	6.3%
m	970561	4.8%
t	968320	4.8%
c	938962	4.7%
Other values (18)	4489268	22.3%

product_name_lenght
Real number (ℝ_≥0)

Distinct	56
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48.50411478
Minimum	5
Maximum	72
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	51
Q3	57
95-th percentile	60
Maximum	72
Range	67
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.997895677
Coefficient of variation (CV)	0.2061246911
Kurtosis	0.2785279607
Mean	48.50411478
Median Absolute Deviation (MAD)	7
Skewness	-0.9087060628
Sum	65752275
Variance	99.95791796
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	93800	6.9%
59	89804	6.6%
55	83562	6.2%
56	78722	5.8%
57	71135	5.2%
58	65507	4.8%
54	53895	4.0%
53	49211	3.6%
52	48213	3.6%
46	46048	3.4%
Other values (46)	675705	49.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	479	< 0.1%
9	80	< 0.1%
11	448	< 0.1%
12	1265	0.1%
14	299	< 0.1%

Value	Count	Frequency (%)
72	89	< 0.1%
64	1965	0.1%
63	14513	1.1%
62	1365	0.1%
61	2523	0.2%

product_description_lenght
Real number (ℝ_≥0)

Distinct	1506
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	782.471859
Minimum	4
Maximum	3976
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	4
5-th percentile	139
Q1	340
median	588
Q3	963
95-th percentile	2213
Maximum	3976
Range	3972
Interquartile range (IQR)	623

Descriptive statistics

Standard deviation	670.0575468
Coefficient of variation (CV)	0.8563343705
Kurtosis	4.220810738
Mean	782.471859
Median Absolute Deviation (MAD)	299
Skewness	1.94172046
Sum	1060720417
Variance	448977.116
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
348	11408	0.8%
341	10070	0.7%
366	9072	0.7%
209	7606	0.6%
919	7339	0.5%
395	7062	0.5%
1197	7057	0.5%
55	6860	0.5%
245	6013	0.4%
189	5523	0.4%
Other values (1496)	1277592	94.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	273	< 0.1%
15	47	< 0.1%
33	184	< 0.1%
36	75	< 0.1%
40	563	< 0.1%

Value	Count	Frequency (%)
3976	426	< 0.1%
3963	965	0.1%
3930	184	< 0.1%
3896	202	< 0.1%
3890	36	< 0.1%

product_photos_qty
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.127696772
Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	14
Range	13
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.659910411
Coefficient of variation (CV)	0.7801442539
Kurtosis	4.084264884
Mean	2.127696772
Median Absolute Deviation (MAD)	0
Skewness	1.889847345
Sum	2884310
Variance	2.755302572
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
1	715164	52.8%
2	267740	19.8%
3	140947	10.4%
4	94587	7.0%
5	58347	4.3%
6	43589	3.2%
7	19243	1.4%
8	7160	0.5%
9	4468	0.3%
10	2675	0.2%
Other values (4)	1682	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	715164	52.8%
2	267740	19.8%
3	140947	10.4%
4	94587	7.0%
5	58347	4.3%

Value	Count	Frequency (%)
14	84	< 0.1%
13	490	< 0.1%
12	531	< 0.1%
11	577	< 0.1%
10	2675	0.2%

product_weight_g
Real number (ℝ_≥0)

Distinct	735
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2095.692298
Minimum	2
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	2
5-th percentile	150
Q1	300
median	700
Q3	1800
95-th percentile	10050
Maximum	30000
Range	29998
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3711.375285
Coefficient of variation (CV)	1.770954299
Kurtosis	13.22308861
Mean	2095.692298
Median Absolute Deviation (MAD)	500
Skewness	3.335602984
Sum	2840924671
Variance	13774306.51
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	90430	6.7%
250	58406	4.3%
150	55611	4.1%
300	51483	3.8%
400	41719	3.1%
350	38018	2.8%
100	36604	2.7%
600	36353	2.7%
500	28153	2.1%
450	23415	1.7%
Other values (725)	895410	66.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	626	< 0.1%
25	352	< 0.1%
50	9593	0.7%
67	34	< 0.1%
75	1735	0.1%

Value	Count	Frequency (%)
30000	1159	0.1%
29050	234	< 0.1%
28300	240	< 0.1%
28250	1224	0.1%
27350	83	< 0.1%

product_length_cm
Real number (ℝ_≥0)

Distinct	91
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	30.65461692
Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	19
median	25
Q3	38
95-th percentile	65
Maximum	105
Range	98
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	16.71502341
Coefficient of variation (CV)	0.5452693621
Kurtosis	3.904944394
Mean	30.65461692
Median Absolute Deviation (MAD)	8
Skewness	1.820451353
Sum	41555460
Variance	279.3920076
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	180776	13.3%
20	138014	10.2%
30	98975	7.3%
17	67316	5.0%
18	66330	4.9%
19	63003	4.6%
25	57693	4.3%
40	54010	4.0%
22	42834	3.2%
21	33767	2.5%
Other values (81)	552884	40.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	691	0.1%
10	520	< 0.1%
11	2439	0.2%
12	488	< 0.1%
13	462	< 0.1%

Value	Count	Frequency (%)
105	8239	0.6%
104	716	0.1%
102	471	< 0.1%
101	888	0.1%
100	4422	0.3%

product_height_cm
Real number (ℝ_≥0)

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.63488767
Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.40669883
Coefficient of variation (CV)	0.8059386452
Kurtosis	7.032585721
Mean	16.63488767
Median Absolute Deviation (MAD)	6
Skewness	2.212346076
Sum	22550287
Variance	179.7395736
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	123993	9.1%
11	95930	7.1%
15	86260	6.4%
20	72006	5.3%
12	65033	4.8%
7	63667	4.7%
5	57462	4.2%
2	56373	4.2%
8	53365	3.9%
16	51362	3.8%
Other values (71)	630151	46.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	56373	4.2%
3	36212	2.7%
4	46790	3.5%
5	57462	4.2%
6	34108	2.5%

Value	Count	Frequency (%)
105	1169	0.1%
104	73	< 0.1%
103	684	0.1%
100	1040	0.1%
95	742	0.1%

product_width_cm
Real number (ℝ_≥0)

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.41726333
Minimum	9
Maximum	118
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	9
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	109
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	12.36974918
Coefficient of variation (CV)	0.5282320572
Kurtosis	5.934172395
Mean	23.41726333
Median Absolute Deviation (MAD)	7
Skewness	1.925422166
Sum	31744489
Variance	153.0106948
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	125728	9.3%
11	112363	8.3%
15	104546	7.7%
30	102793	7.6%
16	99944	7.4%
13	80271	5.9%
12	69186	5.1%
40	59450	4.4%
14	57988	4.3%
25	52388	3.9%
Other values (61)	490945	36.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9	1287	0.1%
10	1097	0.1%
11	112363	8.3%
12	69186	5.1%
13	80271	5.9%

Value	Count	Frequency (%)
118	162	< 0.1%
100	123	< 0.1%
92	6362	0.5%
84	1172	0.1%
83	384	< 0.1%

seller_id
Categorical

HIGH CARDINALITY

Distinct	362
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

6c99c983ce3b6ba0ab813e6790e81691	96500
6b3bd31ad8fcda4b2635ec9f3ff2ecdf	60214
4125d9385a25e82d2f72d3a0fd55bc3f	45505
52a50b42accf164f9f019941e5759d9b	39520
9cf787a239c1aa29dbd76f153dc13f9a	28908
Other values (357)	1084955

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	33cbbec1e7e1044aaf11d152172c776f
2nd row	33cbbec1e7e1044aaf11d152172c776f
3rd row	33cbbec1e7e1044aaf11d152172c776f
4th row	33cbbec1e7e1044aaf11d152172c776f
5th row	33cbbec1e7e1044aaf11d152172c776f

Value	Count	Frequency (%)
6c99c983ce3b6ba0ab813e6790e81691	96500	7.1%
6b3bd31ad8fcda4b2635ec9f3ff2ecdf	60214	4.4%
4125d9385a25e82d2f72d3a0fd55bc3f	45505	3.4%
52a50b42accf164f9f019941e5759d9b	39520	2.9%
9cf787a239c1aa29dbd76f153dc13f9a	28908	2.1%
516e7738bd8f735ac19a010ee5450d8d	26460	2.0%
9c1c0c36cd23c20897e473901a8fb149	25110	1.9%
5f5a58930c3c35f3b5af264f34fb8c85	22848	1.7%
165b1235e9e9942cb5fae67103576fb0	22848	1.7%
c32fc744b9160ac853450488e3cfea93	22848	1.7%
Other values (352)	964841	71.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
6c99c983ce3b6ba0ab813e6790e81691	96500	7.1%
6b3bd31ad8fcda4b2635ec9f3ff2ecdf	60214	4.4%
4125d9385a25e82d2f72d3a0fd55bc3f	45505	3.4%
52a50b42accf164f9f019941e5759d9b	39520	2.9%
9cf787a239c1aa29dbd76f153dc13f9a	28908	2.1%
516e7738bd8f735ac19a010ee5450d8d	26460	2.0%
9c1c0c36cd23c20897e473901a8fb149	25110	1.9%
5f5a58930c3c35f3b5af264f34fb8c85	22848	1.7%
165b1235e9e9942cb5fae67103576fb0	22848	1.7%
c32fc744b9160ac853450488e3cfea93	22848	1.7%
Other values (352)	964841	71.2%

Most occurring characters

Value	Count	Frequency (%)
3	3112454	7.2%
c	3041290	7.0%
9	3037903	7.0%
5	3021523	7.0%
1	2899959	6.7%
8	2792847	6.4%
f	2753940	6.3%
b	2708779	6.2%
a	2638666	6.1%
0	2580002	5.9%
Other values (6)	14791901	34.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27257723	62.8%
Lowercase Letter	16121541	37.2%

Most frequent character per category

Value	Count	Frequency (%)
3	3112454	11.4%
9	3037903	11.1%
5	3021523	11.1%
1	2899959	10.6%
8	2792847	10.2%
0	2580002	9.5%
2	2545006	9.3%
6	2531479	9.3%
4	2385846	8.8%
7	2350704	8.6%

Value	Count	Frequency (%)
c	3041290	18.9%
f	2753940	17.1%
b	2708779	16.8%
a	2638666	16.4%
e	2538186	15.7%
d	2440680	15.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	27257723	62.8%
Latin	16121541	37.2%

Most frequent character per script

Value	Count	Frequency (%)
3	3112454	11.4%
9	3037903	11.1%
5	3021523	11.1%
1	2899959	10.6%
8	2792847	10.2%
0	2580002	9.5%
2	2545006	9.3%
6	2531479	9.3%
4	2385846	8.8%
7	2350704	8.6%

Value	Count	Frequency (%)
c	3041290	18.9%
f	2753940	17.1%
b	2708779	16.8%
a	2638666	16.4%
e	2538186	15.7%
d	2440680	15.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
3	3112454	7.2%
c	3041290	7.0%
9	3037903	7.0%
5	3021523	7.0%
1	2899959	6.7%
8	2792847	6.4%
f	2753940	6.3%
b	2708779	6.2%
a	2638666	6.1%
0	2580002	5.9%
Other values (6)	14791901	34.1%

seller_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	346
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27640.01326
Minimum	1022
Maximum	99670
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1022
5-th percentile	7091
Q1	12306
median	14940
Q3	37410
95-th percentile	89295
Maximum	99670
Range	98648
Interquartile range (IQR)	25104

Descriptive statistics

Standard deviation	25358.88909
Coefficient of variation (CV)	0.9174702216
Kurtosis	1.612837899
Mean	27640.01326
Median Absolute Deviation (MAD)	5899
Skewness	1.685516931
Sum	3.746885726 × 10¹⁰
Variance	643073256.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38400	96500	7.1%
14020	68544	5.1%
22775	60214	4.4%
14940	48048	3.5%
11065	45505	3.4%
30421	42532	3.1%
13820	39520	2.9%
13330	28910	2.1%
14403	28908	2.1%
93700	28724	2.1%
Other values (336)	868197	64.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1022	17	< 0.1%
1023	20	< 0.1%
1026	156	< 0.1%
1031	124	< 0.1%
1041	50	< 0.1%

Value	Count	Frequency (%)
99670	429	< 0.1%
99500	6710	0.5%
98780	1668	0.1%
97050	5397	0.4%
95840	806	0.1%

seller_city
Categorical

HIGH CARDINALITY

Distinct	163
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

rio de janeiro	151539
uberlandia	108657
ribeirao preto	90341
sao paulo	80172
santos	64527
Other values (158)	860366

Length

Max length	26
Median length	10
Mean length	11.12402018
Min length	3

Characters and Unicode

Total characters	15079744
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	bento goncalves
2nd row	bento goncalves
3rd row	bento goncalves
4th row	bento goncalves
5th row	bento goncalves

Value	Count	Frequency (%)
rio de janeiro	151539	11.2%
uberlandia	108657	8.0%
ribeirao preto	90341	6.7%
sao paulo	80172	5.9%
santos	64527	4.8%
belo horizonte	56282	4.2%
praia grande	55019	4.1%
ibitinga	48048	3.5%
santo andre	39646	2.9%
monte alegre do sul	39520	2.9%
Other values (153)	621851	45.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
rio	174491	6.9%
de	157036	6.2%
janeiro	151539	6.0%
sao	148909	5.9%
do	118473	4.7%
uberlandia	108657	4.3%
preto	100501	4.0%
ribeirao	91360	3.6%
paulo	82736	3.3%
sul	75399	3.0%
Other values (187)	1327250	52.3%

Most occurring characters

Value	Count	Frequency (%)
a	2245405	14.9%
o	1638329	10.9%
r	1545623	10.2%
i	1328956	8.8%
e	1226809	8.1%
	1180749	7.8%
n	834046	5.5%
s	649007	4.3%
d	638444	4.2%
t	576758	3.8%
Other values (16)	3215618	21.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13891733	92.1%
Space Separator	1180749	7.8%
Other Punctuation	6732	< 0.1%
Dash Punctuation	530	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	2245405	16.2%
o	1638329	11.8%
r	1545623	11.1%
i	1328956	9.6%
e	1226809	8.8%
n	834046	6.0%
s	649007	4.7%
d	638444	4.6%
t	576758	4.2%
b	501830	3.6%
Other values (13)	2706526	19.5%

Value	Count	Frequency (%)
	1180749	100.0%

Value	Count	Frequency (%)
-	530	100.0%

Value	Count	Frequency (%)
/	6732	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13891733	92.1%
Common	1188011	7.9%

Most frequent character per script

Value	Count	Frequency (%)
a	2245405	16.2%
o	1638329	11.8%
r	1545623	11.1%
i	1328956	9.6%
e	1226809	8.8%
n	834046	6.0%
s	649007	4.7%
d	638444	4.6%
t	576758	4.2%
b	501830	3.6%
Other values (13)	2706526	19.5%

Value	Count	Frequency (%)
	1180749	99.4%
/	6732	0.6%
-	530	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15079744	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	2245405	14.9%
o	1638329	10.9%
r	1545623	10.2%
i	1328956	8.8%
e	1226809	8.1%
	1180749	7.8%
n	834046	5.5%
s	649007	4.3%
d	638444	4.2%
t	576758	3.8%
Other values (16)	3215618	21.3%

seller_state
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

SP	760960
MG	228955
RJ	180581
RS	67266
PR	58708
Other values (8)	59132

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2711204
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RS
2nd row	RS
3rd row	RS
4th row	RS
5th row	RS

Value	Count	Frequency (%)
SP	760960	56.1%
MG	228955	16.9%
RJ	180581	13.3%
RS	67266	5.0%
PR	58708	4.3%
SC	35775	2.6%
GO	9813	0.7%
BA	5961	0.4%
DF	2677	0.2%
ES	2615	0.2%
Other values (3)	2291	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	760960	56.1%
mg	228955	16.9%
rj	180581	13.3%
rs	67266	5.0%
pr	58708	4.3%
sc	35775	2.6%
go	9813	0.7%
ba	5961	0.4%
df	2677	0.2%
es	2615	0.2%
Other values (3)	2291	0.2%

Most occurring characters

Value	Count	Frequency (%)
S	866616	32.0%
P	821696	30.3%
R	306555	11.3%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2711204	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	866616	32.0%
P	821696	30.3%
R	306555	11.3%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2711204	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	866616	32.0%
P	821696	30.3%
R	306555	11.3%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2711204	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	866616	32.0%
P	821696	30.3%
R	306555	11.3%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

geolocation_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	346
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27640.01326
Minimum	1022
Maximum	99670
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1022
5-th percentile	7091
Q1	12306
median	14940
Q3	37410
95-th percentile	89295
Maximum	99670
Range	98648
Interquartile range (IQR)	25104

Descriptive statistics

Standard deviation	25358.88909
Coefficient of variation (CV)	0.9174702216
Kurtosis	1.612837899
Mean	27640.01326
Median Absolute Deviation (MAD)	5899
Skewness	1.685516931
Sum	3.746885726 × 10¹⁰
Variance	643073256.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38400	96500	7.1%
14020	68544	5.1%
22775	60214	4.4%
14940	48048	3.5%
11065	45505	3.4%
30421	42532	3.1%
13820	39520	2.9%
13330	28910	2.1%
14403	28908	2.1%
93700	28724	2.1%
Other values (336)	868197	64.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1022	17	< 0.1%
1023	20	< 0.1%
1026	156	< 0.1%
1031	124	< 0.1%
1041	50	< 0.1%

Value	Count	Frequency (%)
99670	429	< 0.1%
99500	6710	0.5%
98780	1668	0.1%
97050	5397	0.4%
95840	806	0.1%

geolocation_lat
Real number (ℝ)

Distinct	30805
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-22.69291567
Minimum	-36.60537441
Maximum	-3.779843191
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	-36.60537441
5-th percentile	-27.78121345
Q1	-23.65353826
median	-22.90294032
Q3	-21.20790147
95-th percentile	-18.91404141
Maximum	-3.779843191
Range	32.82553122
Interquartile range (IQR)	2.445636783

Descriptive statistics

Standard deviation	2.552272944
Coefficient of variation (CV)	-0.1124700316
Kurtosis	3.863297755
Mean	-22.69291567
Median Absolute Deviation (MAD)	1.062608387
Skewness	-0.005075975693
Sum	-30762561.87
Variance	6.51409718
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.96590556	10591	0.8%
-23.00458225	3204	0.2%
-22.97242436	2737	0.2%
-22.67504552	1748	0.1%
-22.96822472	1547	0.1%
-22.96821901	1547	0.1%
-22.99268742	1428	0.1%
-22.97295472	1428	0.1%
-23.96845861	1425	0.1%
-19.94252559	1372	0.1%
Other values (30795)	1328575	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-36.60537441	12	< 0.1%
-36.60383679	24	< 0.1%
-31.41886478	12	< 0.1%
-30.13422956	20	< 0.1%
-30.12047235	40	< 0.1%

Value	Count	Frequency (%)
-3.779843191	3	< 0.1%
-3.780785137	3	< 0.1%
-3.781066138	3	< 0.1%
-3.781496273	3	< 0.1%
-3.781861785	3	< 0.1%

geolocation_lng
Real number (ℝ)

Distinct	30813
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-46.92442715
Minimum	-64.28743301
Maximum	-34.84768694
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	-64.28743301
5-th percentile	-51.08402284
Q1	-48.2755815
median	-46.89585858
Q3	-46.32862351
95-th percentile	-43.28496162
Maximum	-34.84768694
Range	29.43974607
Interquartile range (IQR)	1.946957993

Descriptive statistics

Standard deviation	2.345820217
Coefficient of variation (CV)	-0.04999145135
Kurtosis	1.577338835
Mean	-46.92442715
Median Absolute Deviation (MAD)	1.286562712
Skewness	0.224370835
Sum	-63610847.29
Variance	5.502872491
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.3899987	10591	0.8%
-43.31989932	3204	0.2%
-43.35950667	2737	0.2%
-46.97723924	1748	0.1%
-43.38651833	1547	0.1%
-43.39477947	1547	0.1%
-43.39238848	1428	0.1%
-43.36546017	1428	0.1%
-46.35377615	1425	0.1%
-43.9755085	1372	0.1%
Other values (30803)	1328575	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-64.28743301	24	< 0.1%
-64.28394646	12	< 0.1%
-60.33626525	12	< 0.1%
-58.12856177	12	< 0.1%
-54.67168166	12	< 0.1%

Value	Count	Frequency (%)
-34.84768694	11	< 0.1%
-34.8477655	11	< 0.1%
-34.84785618	22	< 0.1%
-34.84952568	11	< 0.1%
-34.8500798	11	< 0.1%

geolocation_city
Categorical

HIGH CARDINALITY

Distinct	223
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

rio de janeiro	151539
uberlandia	89571
ribeirao preto	78560
santos	64527
belo horizonte	60972
Other values (218)	910433

Length

Max length	21
Median length	10
Mean length	11.15801688
Min length	3

Characters and Unicode

Total characters	15125830
Distinct characters	36
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	bento goncalves
2nd row	bento goncalves
3rd row	bento goncalves
4th row	bento goncalves
5th row	bento goncalves

Value	Count	Frequency (%)
rio de janeiro	151539	11.2%
uberlandia	89571	6.6%
ribeirao preto	78560	5.8%
santos	64527	4.8%
belo horizonte	60972	4.5%
praia grande	55019	4.1%
sao paulo	51558	3.8%
ibitinga	48048	3.5%
santo andre	39449	2.9%
jaguariuna	35662	2.6%
Other values (213)	680697	50.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
rio	174491	7.1%
de	157036	6.4%
janeiro	151539	6.1%
sao	123725	5.0%
preto	103525	4.2%
do	100310	4.1%
uberlandia	89571	3.6%
ribeirao	78763	3.2%
santos	64527	2.6%
belo	60972	2.5%
Other values (236)	1361410	55.2%

Most occurring characters

Value	Count	Frequency (%)
a	2283543	15.1%
o	1597031	10.6%
r	1590989	10.5%
i	1380163	9.1%
e	1177226	7.8%
	1110267	7.3%
n	873332	5.8%
d	633728	4.2%
s	610957	4.0%
t	565919	3.7%
Other values (26)	3302675	21.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14012463	92.6%
Space Separator	1110267	7.3%
Dash Punctuation	1768	< 0.1%
Other Punctuation	1332	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	2283543	16.3%
o	1597031	11.4%
r	1590989	11.4%
i	1380163	9.8%
e	1177226	8.4%
n	873332	6.2%
d	633728	4.5%
s	610957	4.4%
t	565919	4.0%
u	522264	3.7%
Other values (23)	2777311	19.8%

Value	Count	Frequency (%)
	1110267	100.0%

Value	Count	Frequency (%)
'	1332	100.0%

Value	Count	Frequency (%)
-	1768	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14012463	92.6%
Common	1113367	7.4%

Most frequent character per script

Value	Count	Frequency (%)
a	2283543	16.3%
o	1597031	11.4%
r	1590989	11.4%
i	1380163	9.8%
e	1177226	8.4%
n	873332	6.2%
d	633728	4.5%
s	610957	4.4%
t	565919	4.0%
u	522264	3.7%
Other values (23)	2777311	19.8%

Value	Count	Frequency (%)
	1110267	99.7%
-	1768	0.2%
'	1332	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15025924	99.3%
None	99906	0.7%

Most frequent character per block

Value	Count	Frequency (%)
a	2283543	15.2%
o	1597031	10.6%
r	1590989	10.6%
i	1380163	9.2%
e	1177226	7.8%
	1110267	7.4%
n	873332	5.8%
d	633728	4.2%
s	610957	4.1%
t	565919	3.8%
Other values (16)	3202769	21.3%

Value	Count	Frequency (%)
ã	40186	40.2%
â	20057	20.1%
é	10228	10.2%
í	7091	7.1%
ç	6920	6.9%
á	5314	5.3%
ó	3172	3.2%
ú	2504	2.5%
ê	2343	2.3%
õ	2091	2.1%

geolocation_state
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

SP	759198
MG	228955
RJ	180581
RS	67266
PR	60470
Other values (8)	59132

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2711204
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RS
2nd row	RS
3rd row	RS
4th row	RS
5th row	RS

Value	Count	Frequency (%)
SP	759198	56.0%
MG	228955	16.9%
RJ	180581	13.3%
RS	67266	5.0%
PR	60470	4.5%
SC	35775	2.6%
GO	9813	0.7%
BA	5961	0.4%
DF	2677	0.2%
ES	2615	0.2%
Other values (3)	2291	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	759198	56.0%
mg	228955	16.9%
rj	180581	13.3%
rs	67266	5.0%
pr	60470	4.5%
sc	35775	2.6%
go	9813	0.7%
ba	5961	0.4%
df	2677	0.2%
es	2615	0.2%
Other values (3)	2291	0.2%

Most occurring characters

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2711204	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2711204	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2711204	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

customer_unique_id
Categorical

HIGH CARDINALITY

Distinct	4322
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

c0536ee7a009264e0f1bf1c8f4c54ad3	7344
f7ea4eef770a388bd5b225acfc546604	6860
31e412b9fb766b6794724ed17a41dfa6	6706
37d2d1ac62901f9a36cff32ca86c9337	5790
38a4f1deb45ca914dd13c73b41775d71	5200
Other values (4317)	1323702

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0299fedc3f190307e87f32483a9ba4fd
2nd row	0299fedc3f190307e87f32483a9ba4fd
3rd row	0299fedc3f190307e87f32483a9ba4fd
4th row	0299fedc3f190307e87f32483a9ba4fd
5th row	0299fedc3f190307e87f32483a9ba4fd

Value	Count	Frequency (%)
c0536ee7a009264e0f1bf1c8f4c54ad3	7344	0.5%
f7ea4eef770a388bd5b225acfc546604	6860	0.5%
31e412b9fb766b6794724ed17a41dfa6	6706	0.5%
37d2d1ac62901f9a36cff32ca86c9337	5790	0.4%
38a4f1deb45ca914dd13c73b41775d71	5200	0.4%
ed04da2a9e4d7cb3eae84074a2822567	4896	0.4%
ae977f6cf6981d883940f7e618620b3e	4896	0.4%
c01ac50f437f46cc8fffb6d1a01d8631	4340	0.3%
6469f99c1f9dfae7733b25662e7f1782	4311	0.3%
6d394722d5fc5e721aee6875a218d8db	4048	0.3%
Other values (4312)	1301211	96.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
c0536ee7a009264e0f1bf1c8f4c54ad3	7344	0.5%
f7ea4eef770a388bd5b225acfc546604	6860	0.5%
31e412b9fb766b6794724ed17a41dfa6	6706	0.5%
37d2d1ac62901f9a36cff32ca86c9337	5790	0.4%
38a4f1deb45ca914dd13c73b41775d71	5200	0.4%
ed04da2a9e4d7cb3eae84074a2822567	4896	0.4%
ae977f6cf6981d883940f7e618620b3e	4896	0.4%
c01ac50f437f46cc8fffb6d1a01d8631	4340	0.3%
6469f99c1f9dfae7733b25662e7f1782	4311	0.3%
6d394722d5fc5e721aee6875a218d8db	4048	0.3%
Other values (4312)	1301211	96.0%

Most occurring characters

Value	Count	Frequency (%)
6	2799933	6.5%
f	2772626	6.4%
c	2768305	6.4%
a	2765491	6.4%
2	2752555	6.3%
1	2733068	6.3%
5	2732417	6.3%
7	2729395	6.3%
d	2703601	6.2%
b	2698264	6.2%
Other values (6)	15923609	36.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26982060	62.2%
Lowercase Letter	16397204	37.8%

Most frequent character per category

Value	Count	Frequency (%)
6	2799933	10.4%
2	2752555	10.2%
1	2733068	10.1%
5	2732417	10.1%
7	2729395	10.1%
4	2696492	10.0%
0	2659215	9.9%
3	2652971	9.8%
8	2621919	9.7%
9	2604095	9.7%

Value	Count	Frequency (%)
f	2772626	16.9%
c	2768305	16.9%
a	2765491	16.9%
d	2703601	16.5%
b	2698264	16.5%
e	2688917	16.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	26982060	62.2%
Latin	16397204	37.8%

Most frequent character per script

Value	Count	Frequency (%)
6	2799933	10.4%
2	2752555	10.2%
1	2733068	10.1%
5	2732417	10.1%
7	2729395	10.1%
4	2696492	10.0%
0	2659215	9.9%
3	2652971	9.8%
8	2621919	9.7%
9	2604095	9.7%

Value	Count	Frequency (%)
f	2772626	16.9%
c	2768305	16.9%
a	2765491	16.9%
d	2703601	16.5%
b	2698264	16.5%
e	2688917	16.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
6	2799933	6.5%
f	2772626	6.4%
c	2768305	6.4%
a	2765491	6.4%
2	2752555	6.3%
1	2733068	6.3%
5	2732417	6.3%
7	2729395	6.3%
d	2703601	6.2%
b	2698264	6.2%
Other values (6)	15923609	36.7%

customer_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	346
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27640.01326
Minimum	1022
Maximum	99670
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 MiB

Quantile statistics

Minimum	1022
5-th percentile	7091
Q1	12306
median	14940
Q3	37410
95-th percentile	89295
Maximum	99670
Range	98648
Interquartile range (IQR)	25104

Descriptive statistics

Standard deviation	25358.88909
Coefficient of variation (CV)	0.9174702216
Kurtosis	1.612837899
Mean	27640.01326
Median Absolute Deviation (MAD)	5899
Skewness	1.685516931
Sum	3.746885726 × 10¹⁰
Variance	643073256.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38400	96500	7.1%
14020	68544	5.1%
22775	60214	4.4%
14940	48048	3.5%
11065	45505	3.4%
30421	42532	3.1%
13820	39520	2.9%
13330	28910	2.1%
14403	28908	2.1%
93700	28724	2.1%
Other values (336)	868197	64.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1022	17	< 0.1%
1023	20	< 0.1%
1026	156	< 0.1%
1031	124	< 0.1%
1041	50	< 0.1%

Value	Count	Frequency (%)
99670	429	< 0.1%
99500	6710	0.5%
98780	1668	0.1%
97050	5397	0.4%
95840	806	0.1%

customer_city
Categorical

HIGH CARDINALITY

Distinct	155
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

rio de janeiro	151539
uberlandia	108657
ribeirao preto	94125
santos	64527
belo horizonte	60972
Other values (150)	875782

Length

Max length	21
Median length	10
Mean length	11.15866088
Min length	3

Characters and Unicode

Total characters	15126703
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	bento goncalves
2nd row	bento goncalves
3rd row	bento goncalves
4th row	bento goncalves
5th row	bento goncalves

Value	Count	Frequency (%)
rio de janeiro	151539	11.2%
uberlandia	108657	8.0%
ribeirao preto	94125	6.9%
santos	64527	4.8%
belo horizonte	60972	4.5%
sao paulo	60660	4.5%
praia grande	55019	4.1%
ibitinga	48048	3.5%
santo andre	47272	3.5%
jaguariuna	37998	2.8%
Other values (145)	626785	46.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
rio	174491	7.1%
de	157036	6.4%
janeiro	151539	6.1%
sao	146481	5.9%
uberlandia	108657	4.4%
preto	103525	4.2%
do	100161	4.1%
ribeirao	94384	3.8%
santos	64527	2.6%
horizonte	60972	2.5%
Other values (179)	1302638	52.9%

Most occurring characters

Value	Count	Frequency (%)
a	2349969	15.5%
o	1601901	10.6%
r	1591243	10.5%
i	1387415	9.2%
e	1189475	7.9%
	1108809	7.3%
n	873322	5.8%
d	633814	4.2%
s	611317	4.0%
t	566034	3.7%
Other values (16)	3213404	21.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14013314	92.6%
Space Separator	1108809	7.3%
Dash Punctuation	3068	< 0.1%
Other Punctuation	1512	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	2349969	16.8%
o	1601901	11.4%
r	1591243	11.4%
i	1387415	9.9%
e	1189475	8.5%
n	873322	6.2%
d	633814	4.5%
s	611317	4.4%
t	566034	4.0%
u	524968	3.7%
Other values (13)	2683856	19.2%

Value	Count	Frequency (%)
	1108809	100.0%

Value	Count	Frequency (%)
'	1512	100.0%

Value	Count	Frequency (%)
-	3068	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14013314	92.6%
Common	1113389	7.4%

Most frequent character per script

Value	Count	Frequency (%)
a	2349969	16.8%
o	1601901	11.4%
r	1591243	11.4%
i	1387415	9.9%
e	1189475	8.5%
n	873322	6.2%
d	633814	4.5%
s	611317	4.4%
t	566034	4.0%
u	524968	3.7%
Other values (13)	2683856	19.2%

Value	Count	Frequency (%)
	1108809	99.6%
-	3068	0.3%
'	1512	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15126703	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	2349969	15.5%
o	1601901	10.6%
r	1591243	10.5%
i	1387415	9.2%
e	1189475	7.9%
	1108809	7.3%
n	873322	5.8%
d	633814	4.2%
s	611317	4.0%
t	566034	3.7%
Other values (16)	3213404	21.2%

customer_state
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

SP	759198
MG	228955
RJ	180581
RS	67266
PR	60470
Other values (8)	59132

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2711204
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RS
2nd row	RS
3rd row	RS
4th row	RS
5th row	RS

Value	Count	Frequency (%)
SP	759198	56.0%
MG	228955	16.9%
RJ	180581	13.3%
RS	67266	5.0%
PR	60470	4.5%
SC	35775	2.6%
GO	9813	0.7%
BA	5961	0.4%
DF	2677	0.2%
ES	2615	0.2%
Other values (3)	2291	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	759198	56.0%
mg	228955	16.9%
rj	180581	13.3%
rs	67266	5.0%
pr	60470	4.5%
sc	35775	2.6%
go	9813	0.7%
ba	5961	0.4%
df	2677	0.2%
es	2615	0.2%
Other values (3)	2291	0.2%

Most occurring characters

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2711204	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2711204	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2711204	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	864854	31.9%
P	821696	30.3%
R	308317	11.4%
G	238768	8.8%
M	228955	8.4%
J	180581	6.7%
C	36038	1.3%
O	9813	0.4%
B	6357	0.2%
A	5961	0.2%
Other values (3)	9864	0.4%

mql_id
Categorical

HIGH CARDINALITY

Distinct	362
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

973f72ab89f64e22470778a9bd1ea10f	96500
a0ab09eb2842e474a3a5aed12e533a2a	60214
d6e0ddfc5b05597877a7d5036789a3a1	45505
085df4d5a370218b679cfab2121cd194	39520
42d15f0a37b7d0a151bb2ca9cc7e5548	28908
Other values (357)	1084955

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1ce04284ef15be769958c668292573b8
2nd row	1ce04284ef15be769958c668292573b8
3rd row	1ce04284ef15be769958c668292573b8
4th row	1ce04284ef15be769958c668292573b8
5th row	1ce04284ef15be769958c668292573b8

Value	Count	Frequency (%)
973f72ab89f64e22470778a9bd1ea10f	96500	7.1%
a0ab09eb2842e474a3a5aed12e533a2a	60214	4.4%
d6e0ddfc5b05597877a7d5036789a3a1	45505	3.4%
085df4d5a370218b679cfab2121cd194	39520	2.9%
42d15f0a37b7d0a151bb2ca9cc7e5548	28908	2.1%
e0bcbf50b9afa71ee130b94dfe8bcf2e	26460	2.0%
7290c4082936311a3295b7c9ca7bda8f	25110	1.9%
66744053f818d4032f5ba881340db020	22848	1.7%
a58f8a3280b2dd6440d88af9decb9b1f	22848	1.7%
3469f647707d7517364600b07bd45816	22848	1.7%
Other values (352)	964841	71.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
973f72ab89f64e22470778a9bd1ea10f	96500	7.1%
a0ab09eb2842e474a3a5aed12e533a2a	60214	4.4%
d6e0ddfc5b05597877a7d5036789a3a1	45505	3.4%
085df4d5a370218b679cfab2121cd194	39520	2.9%
42d15f0a37b7d0a151bb2ca9cc7e5548	28908	2.1%
e0bcbf50b9afa71ee130b94dfe8bcf2e	26460	2.0%
7290c4082936311a3295b7c9ca7bda8f	25110	1.9%
66744053f818d4032f5ba881340db020	22848	1.7%
a58f8a3280b2dd6440d88af9decb9b1f	22848	1.7%
3469f647707d7517364600b07bd45816	22848	1.7%
Other values (352)	964841	71.2%

Most occurring characters

Value	Count	Frequency (%)
7	3133291	7.2%
a	3090580	7.1%
2	2865346	6.6%
8	2825141	6.5%
1	2798133	6.5%
e	2797516	6.4%
0	2792522	6.4%
4	2777646	6.4%
b	2759333	6.4%
f	2679634	6.2%
Other values (6)	14860122	34.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27232075	62.8%
Lowercase Letter	16147189	37.2%

Most frequent character per category

Value	Count	Frequency (%)
7	3133291	11.5%
2	2865346	10.5%
8	2825141	10.4%
1	2798133	10.3%
0	2792522	10.3%
4	2777646	10.2%
5	2646894	9.7%
9	2622569	9.6%
3	2542385	9.3%
6	2228148	8.2%

Value	Count	Frequency (%)
a	3090580	19.1%
e	2797516	17.3%
b	2759333	17.1%
f	2679634	16.6%
d	2590115	16.0%
c	2230011	13.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	27232075	62.8%
Latin	16147189	37.2%

Most frequent character per script

Value	Count	Frequency (%)
7	3133291	11.5%
2	2865346	10.5%
8	2825141	10.4%
1	2798133	10.3%
0	2792522	10.3%
4	2777646	10.2%
5	2646894	9.7%
9	2622569	9.6%
3	2542385	9.3%
6	2228148	8.2%

Value	Count	Frequency (%)
a	3090580	19.1%
e	2797516	17.3%
b	2759333	17.1%
f	2679634	16.6%
d	2590115	16.0%
c	2230011	13.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
7	3133291	7.2%
a	3090580	7.1%
2	2865346	6.6%
8	2825141	6.5%
1	2798133	6.5%
e	2797516	6.4%
0	2792522	6.4%
4	2777646	6.4%
b	2759333	6.4%
f	2679634	6.2%
Other values (6)	14860122	34.3%

sdr_id
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

4b339f9567d060bcea4f5136b9f5949e	236790
068066e24f0c643eb1d089c7dd20cd73	216836
a8387c01a09e99ce014107505b92388c	139492
de63de0d10a6012430098db33c679b0b	123186
9e4d1098a3b0f5da39b0bc48f9876645	119939
Other values (13)	519359

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	de63de0d10a6012430098db33c679b0b
2nd row	de63de0d10a6012430098db33c679b0b
3rd row	de63de0d10a6012430098db33c679b0b
4th row	de63de0d10a6012430098db33c679b0b
5th row	de63de0d10a6012430098db33c679b0b

Value	Count	Frequency (%)
4b339f9567d060bcea4f5136b9f5949e	236790	17.5%
068066e24f0c643eb1d089c7dd20cd73	216836	16.0%
a8387c01a09e99ce014107505b92388c	139492	10.3%
de63de0d10a6012430098db33c679b0b	123186	9.1%
9e4d1098a3b0f5da39b0bc48f9876645	119939	8.8%
9d12ef1a7eca3ec58c545c678af7869c	84778	6.3%
56bf83c4bb35763a51c2baab501b4c67	76345	5.6%
370c9f455f93a9a96cbe9bea48e70033	73764	5.4%
b90f87164b5f8c2cfa5c8572834dbe3f	62057	4.6%
0a0fb2b07d841f84fb6714e35c723075	60508	4.5%
Other values (8)	161907	11.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
4b339f9567d060bcea4f5136b9f5949e	236790	17.5%
068066e24f0c643eb1d089c7dd20cd73	216836	16.0%
a8387c01a09e99ce014107505b92388c	139492	10.3%
de63de0d10a6012430098db33c679b0b	123186	9.1%
9e4d1098a3b0f5da39b0bc48f9876645	119939	8.8%
9d12ef1a7eca3ec58c545c678af7869c	84778	6.3%
56bf83c4bb35763a51c2baab501b4c67	76345	5.6%
370c9f455f93a9a96cbe9bea48e70033	73764	5.4%
b90f87164b5f8c2cfa5c8572834dbe3f	62057	4.6%
0a0fb2b07d841f84fb6714e35c723075	60508	4.5%
Other values (8)	161907	11.9%

Most occurring characters

Value	Count	Frequency (%)
0	4463983	10.3%
9	3697399	8.5%
3	3198551	7.4%
b	3152187	7.3%
6	3092574	7.1%
c	2823108	6.5%
4	2749016	6.3%
5	2632019	6.1%
8	2504734	5.8%
d	2428297	5.6%
Other values (6)	12637396	29.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28401668	65.5%
Lowercase Letter	14977596	34.5%

Most frequent character per category

Value	Count	Frequency (%)
0	4463983	15.7%
9	3697399	13.0%
3	3198551	11.3%
6	3092574	10.9%
4	2749016	9.7%
5	2632019	9.3%
8	2504734	8.8%
7	2333875	8.2%
1	2161898	7.6%
2	1567619	5.5%

Value	Count	Frequency (%)
b	3152187	21.0%
c	2823108	18.8%
d	2428297	16.2%
e	2370297	15.8%
f	2306075	15.4%
a	1897632	12.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	28401668	65.5%
Latin	14977596	34.5%

Most frequent character per script

Value	Count	Frequency (%)
0	4463983	15.7%
9	3697399	13.0%
3	3198551	11.3%
6	3092574	10.9%
4	2749016	9.7%
5	2632019	9.3%
8	2504734	8.8%
7	2333875	8.2%
1	2161898	7.6%
2	1567619	5.5%

Value	Count	Frequency (%)
b	3152187	21.0%
c	2823108	18.8%
d	2428297	16.2%
e	2370297	15.8%
f	2306075	15.4%
a	1897632	12.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4463983	10.3%
9	3697399	8.5%
3	3198551	7.4%
b	3152187	7.3%
6	3092574	7.1%
c	2823108	6.5%
4	2749016	6.3%
5	2632019	6.1%
8	2504734	5.8%
d	2428297	5.6%
Other values (6)	12637396	29.1%

sr_id
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

d3d1e91a157ea7f90548eef82f1955e3	282247
4ef15afb4b2723d8f3d81e51ec7afefe	264075
495d4e95a8cf8bbf8b432b612a2aa328	134044
fbf4aef3f6915dc0c3c97d6812522f6a	127357
6565aa9ce3178a5caf6171827af3a9ba	116736
Other values (13)	431143

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6565aa9ce3178a5caf6171827af3a9ba
2nd row	6565aa9ce3178a5caf6171827af3a9ba
3rd row	6565aa9ce3178a5caf6171827af3a9ba
4th row	6565aa9ce3178a5caf6171827af3a9ba
5th row	6565aa9ce3178a5caf6171827af3a9ba

Value	Count	Frequency (%)
d3d1e91a157ea7f90548eef82f1955e3	282247	20.8%
4ef15afb4b2723d8f3d81e51ec7afefe	264075	19.5%
495d4e95a8cf8bbf8b432b612a2aa328	134044	9.9%
fbf4aef3f6915dc0c3c97d6812522f6a	127357	9.4%
6565aa9ce3178a5caf6171827af3a9ba	116736	8.6%
85fc447d336637ba1df43e793199fbc8	76734	5.7%
a8387c01a09e99ce014107505b92388c	75509	5.6%
9e4d1098a3b0f5da39b0bc48f9876645	67632	5.0%
2695de1affa7750089c0455f8ce27021	42056	3.1%
9ae085775a198122c5586fa830ff7f2b	40216	3.0%
Other values (8)	128996	9.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
d3d1e91a157ea7f90548eef82f1955e3	282247	20.8%
4ef15afb4b2723d8f3d81e51ec7afefe	264075	19.5%
495d4e95a8cf8bbf8b432b612a2aa328	134044	9.9%
fbf4aef3f6915dc0c3c97d6812522f6a	127357	9.4%
6565aa9ce3178a5caf6171827af3a9ba	116736	8.6%
85fc447d336637ba1df43e793199fbc8	76734	5.7%
a8387c01a09e99ce014107505b92388c	75509	5.6%
9e4d1098a3b0f5da39b0bc48f9876645	67632	5.0%
2695de1affa7750089c0455f8ce27021	42056	3.1%
9ae085775a198122c5586fa830ff7f2b	40216	3.0%
Other values (8)	128996	9.5%

Most occurring characters

Value	Count	Frequency (%)
f	4117504	9.5%
e	3706573	8.5%
1	3529533	8.1%
a	3470629	8.0%
5	3380770	7.8%
8	3108466	7.2%
3	2843894	6.6%
9	2819360	6.5%
7	2453784	5.7%
2	2341790	5.4%
Other values (6)	11606961	26.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25981359	59.9%
Lowercase Letter	17397905	40.1%

Most frequent character per category

Value	Count	Frequency (%)
1	3529533	13.6%
5	3380770	13.0%
8	3108466	12.0%
3	2843894	10.9%
9	2819360	10.9%
7	2453784	9.4%
2	2341790	9.0%
4	2127336	8.2%
0	1708284	6.6%
6	1668142	6.4%

Value	Count	Frequency (%)
f	4117504	23.7%
e	3706573	21.3%
a	3470629	19.9%
b	2117966	12.2%
d	2116386	12.2%
c	1868847	10.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	25981359	59.9%
Latin	17397905	40.1%

Most frequent character per script

Value	Count	Frequency (%)
1	3529533	13.6%
5	3380770	13.0%
8	3108466	12.0%
3	2843894	10.9%
9	2819360	10.9%
7	2453784	9.4%
2	2341790	9.0%
4	2127336	8.2%
0	1708284	6.6%
6	1668142	6.4%

Value	Count	Frequency (%)
f	4117504	23.7%
e	3706573	21.3%
a	3470629	19.9%
b	2117966	12.2%
d	2116386	12.2%
c	1868847	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
f	4117504	9.5%
e	3706573	8.5%
1	3529533	8.1%
a	3470629	8.0%
5	3380770	7.8%
8	3108466	7.2%
3	2843894	6.6%
9	2819360	6.5%
7	2453784	5.7%
2	2341790	5.4%
Other values (6)	11606961	26.8%

won_date
Categorical

HIGH CARDINALITY

Distinct	354
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-04-16 18:25:12	96500
2018-03-13 18:53:47	60214
2018-05-04 03:00:00	59027
2018-04-05 15:06:11	45505
2018-01-24 12:27:42	28908
Other values (349)	1065448

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	25756438
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018-03-06 13:27:32
2nd row	2018-03-06 13:27:32
3rd row	2018-03-06 13:27:32
4th row	2018-03-06 13:27:32
5th row	2018-03-06 13:27:32

Value	Count	Frequency (%)
2018-04-16 18:25:12	96500	7.1%
2018-03-13 18:53:47	60214	4.4%
2018-05-04 03:00:00	59027	4.4%
2018-04-05 15:06:11	45505	3.4%
2018-01-24 12:27:42	28908	2.1%
2018-05-08 13:32:34	26460	2.0%
2018-03-19 20:26:27	25110	1.9%
2018-04-30 16:01:35	22848	1.7%
2018-02-26 17:07:06	22848	1.7%
2018-03-05 20:54:03	22848	1.7%
Other values (344)	945334	69.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-16	102648	3.8%
18:25:12	96500	3.6%
03:00:00	89504	3.3%
2018-03-13	74342	2.7%
18:53:47	60214	2.2%
2018-05-04	59027	2.2%
2018-04-05	56276	2.1%
15:06:11	45505	1.7%
2018-02-26	44350	1.6%
2018-05-08	43123	1.6%
Other values (436)	2039715	75.2%

Most occurring characters

Value	Count	Frequency (%)
0	4580380	17.8%
1	3863691	15.0%
2	3240327	12.6%
-	2711204	10.5%
:	2711204	10.5%
8	1980712	7.7%
	1355602	5.3%
4	1303849	5.1%
3	1195546	4.6%
5	1152867	4.5%
Other values (3)	1661056	6.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18978428	73.7%
Dash Punctuation	2711204	10.5%
Other Punctuation	2711204	10.5%
Space Separator	1355602	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	4580380	24.1%
1	3863691	20.4%
2	3240327	17.1%
8	1980712	10.4%
4	1303849	6.9%
3	1195546	6.3%
5	1152867	6.1%
6	687455	3.6%
7	587283	3.1%
9	386318	2.0%

Value	Count	Frequency (%)
-	2711204	100.0%

Value	Count	Frequency (%)
	1355602	100.0%

Value	Count	Frequency (%)
:	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25756438	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4580380	17.8%
1	3863691	15.0%
2	3240327	12.6%
-	2711204	10.5%
:	2711204	10.5%
8	1980712	7.7%
	1355602	5.3%
4	1303849	5.1%
3	1195546	4.6%
5	1152867	4.5%
Other values (3)	1661056	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25756438	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4580380	17.8%
1	3863691	15.0%
2	3240327	12.6%
-	2711204	10.5%
:	2711204	10.5%
8	1980712	7.7%
	1355602	5.3%
4	1303849	5.1%
3	1195546	4.6%
5	1152867	4.5%
Other values (3)	1661056	6.4%

business_segment
Categorical

HIGH CORRELATION

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

home_decor	202484
health_beauty	121177
toys	110649
car_accessories	108835
construction_tools_house_garden	108198
Other values (24)	704259

Length

Max length	31
Median length	13
Mean length	13.8465796
Min length	3

Characters and Unicode

Total characters	18770451
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	household_utilities
2nd row	household_utilities
3rd row	household_utilities
4th row	household_utilities
5th row	household_utilities

Value	Count	Frequency (%)
home_decor	202484	14.9%
health_beauty	121177	8.9%
toys	110649	8.2%
car_accessories	108835	8.0%
construction_tools_house_garden	108198	8.0%
food_supplement	97811	7.2%
food_drink	86545	6.4%
household_utilities	84483	6.2%
audio_video_electronics	75458	5.6%
pet	42638	3.1%
Other values (19)	317324	23.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
home_decor	202484	14.9%
health_beauty	121177	8.9%
toys	110649	8.2%
car_accessories	108835	8.0%
construction_tools_house_garden	108198	8.0%
food_supplement	97811	7.2%
food_drink	86545	6.4%
household_utilities	84483	6.2%
audio_video_electronics	75458	5.6%
pet	42638	3.1%
Other values (19)	317324	23.4%

Most occurring characters

Value	Count	Frequency (%)
o	2201219	11.7%
e	2065706	11.0%
s	1547969	8.2%
_	1422957	7.6%
t	1275095	6.8%
c	1146515	6.1%
i	1062773	5.7%
a	1010966	5.4%
r	993894	5.3%
d	873867	4.7%
Other values (13)	5169490	27.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17347494	92.4%
Connector Punctuation	1422957	7.6%

Most frequent character per category

Value	Count	Frequency (%)
o	2201219	12.7%
e	2065706	11.9%
s	1547969	8.9%
t	1275095	7.4%
c	1146515	6.6%
i	1062773	6.1%
a	1010966	5.8%
r	993894	5.7%
d	873867	5.0%
h	833389	4.8%
Other values (12)	4336101	25.0%

Value	Count	Frequency (%)
_	1422957	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17347494	92.4%
Common	1422957	7.6%

Most frequent character per script

Value	Count	Frequency (%)
o	2201219	12.7%
e	2065706	11.9%
s	1547969	8.9%
t	1275095	7.4%
c	1146515	6.6%
i	1062773	6.1%
a	1010966	5.8%
r	993894	5.7%
d	873867	5.0%
h	833389	4.8%
Other values (12)	4336101	25.0%

Value	Count	Frequency (%)
_	1422957	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18770451	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	2201219	11.7%
e	2065706	11.0%
s	1547969	8.2%
_	1422957	7.6%
t	1275095	6.8%
c	1146515	6.1%
i	1062773	5.7%
a	1010966	5.4%
r	993894	5.3%
d	873867	4.7%
Other values (13)	5169490	27.5%

lead_type
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

online_medium	598266
online_small	275414
online_big	260802
industry	99146
offline	65726
Other values (2)	56248

Length

Max length	15
Median length	12
Mean length	11.60306712
Min length	7

Characters and Unicode

Total characters	15729141
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	online_big
2nd row	online_big
3rd row	online_big
4th row	online_big
5th row	online_big

Value	Count	Frequency (%)
online_medium	598266	44.1%
online_small	275414	20.3%
online_big	260802	19.2%
industry	99146	7.3%
offline	65726	4.8%
online_beginner	44593	3.3%
online_top	11655	0.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
online_medium	598266	44.1%
online_small	275414	20.3%
online_big	260802	19.2%
industry	99146	7.3%
offline	65726	4.8%
online_beginner	44593	3.3%
online_top	11655	0.9%

Most occurring characters

Value	Count	Frequency (%)
n	2635518	16.8%
i	2259263	14.4%
e	1943908	12.4%
l	1807284	11.5%
m	1471946	9.4%
o	1268111	8.1%
_	1190730	7.6%
d	697412	4.4%
u	697412	4.4%
s	374560	2.4%
Other values (8)	1382997	8.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14538411	92.4%
Connector Punctuation	1190730	7.6%

Most frequent character per category

Value	Count	Frequency (%)
n	2635518	18.1%
i	2259263	15.5%
e	1943908	13.4%
l	1807284	12.4%
m	1471946	10.1%
o	1268111	8.7%
d	697412	4.8%
u	697412	4.8%
s	374560	2.6%
b	305395	2.1%
Other values (7)	1077602	7.4%

Value	Count	Frequency (%)
_	1190730	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14538411	92.4%
Common	1190730	7.6%

Most frequent character per script

Value	Count	Frequency (%)
n	2635518	18.1%
i	2259263	15.5%
e	1943908	13.4%
l	1807284	12.4%
m	1471946	10.1%
o	1268111	8.7%
d	697412	4.8%
u	697412	4.8%
s	374560	2.6%
b	305395	2.1%
Other values (7)	1077602	7.4%

Value	Count	Frequency (%)
_	1190730	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15729141	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	2635518	16.8%
i	2259263	14.4%
e	1943908	12.4%
l	1807284	11.5%
m	1471946	9.4%
o	1268111	8.1%
_	1190730	7.6%
d	697412	4.4%
u	697412	4.4%
s	374560	2.4%
Other values (8)	1382997	8.8%

lead_behaviour_profile
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

cat	997828
wolf	154936
eagle	147775
shark	29128
cat, wolf	21266

Length

Max length	10
Median length	3
Mean length	3.493523173
Min length	3

Characters and Unicode

Total characters	4735827
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cat
2nd row	cat
3rd row	cat
4th row	cat
5th row	cat

Value	Count	Frequency (%)
cat	997828	73.6%
wolf	154936	11.4%
eagle	147775	10.9%
shark	29128	2.1%
cat, wolf	21266	1.6%
eagle, cat	4669	0.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
cat	1023763	74.1%
wolf	176202	12.8%
eagle	152444	11.0%
shark	29128	2.1%

Most occurring characters

Value	Count	Frequency (%)
a	1205335	25.5%
c	1023763	21.6%
t	1023763	21.6%
l	328646	6.9%
e	304888	6.4%
w	176202	3.7%
o	176202	3.7%
f	176202	3.7%
g	152444	3.2%
s	29128	0.6%
Other values (5)	139254	2.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4683957	98.9%
Other Punctuation	25935	0.5%
Space Separator	25935	0.5%

Most frequent character per category

Value	Count	Frequency (%)
a	1205335	25.7%
c	1023763	21.9%
t	1023763	21.9%
l	328646	7.0%
e	304888	6.5%
w	176202	3.8%
o	176202	3.8%
f	176202	3.8%
g	152444	3.3%
s	29128	0.6%
Other values (3)	87384	1.9%

Value	Count	Frequency (%)
,	25935	100.0%

Value	Count	Frequency (%)
	25935	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4683957	98.9%
Common	51870	1.1%

Most frequent character per script

Value	Count	Frequency (%)
a	1205335	25.7%
c	1023763	21.9%
t	1023763	21.9%
l	328646	7.0%
e	304888	6.5%
w	176202	3.8%
o	176202	3.8%
f	176202	3.8%
g	152444	3.3%
s	29128	0.6%
Other values (3)	87384	1.9%

Value	Count	Frequency (%)
,	25935	50.0%
	25935	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4735827	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	1205335	25.5%
c	1023763	21.6%
t	1023763	21.6%
l	328646	6.9%
e	304888	6.4%
w	176202	3.7%
o	176202	3.7%
f	176202	3.7%
g	152444	3.2%
s	29128	0.6%
Other values (5)	139254	2.9%

business_type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

reseller	1038366
manufacturer	317236

Length

Max length	12
Median length	8
Mean length	8.936074157
Min length	8

Characters and Unicode

Total characters	12113760
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	reseller
2nd row	reseller
3rd row	reseller
4th row	reseller
5th row	reseller

Value	Count	Frequency (%)
reseller	1038366	76.6%
manufacturer	317236	23.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
reseller	1038366	76.6%
manufacturer	317236	23.4%

Most occurring characters

Value	Count	Frequency (%)
e	3432334	28.3%
r	2711204	22.4%
l	2076732	17.1%
s	1038366	8.6%
a	634472	5.2%
u	634472	5.2%
m	317236	2.6%
n	317236	2.6%
f	317236	2.6%
c	317236	2.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12113760	100.0%

Most frequent character per category

Value	Count	Frequency (%)
e	3432334	28.3%
r	2711204	22.4%
l	2076732	17.1%
s	1038366	8.6%
a	634472	5.2%
u	634472	5.2%
m	317236	2.6%
n	317236	2.6%
f	317236	2.6%
c	317236	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12113760	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	3432334	28.3%
r	2711204	22.4%
l	2076732	17.1%
s	1038366	8.6%
a	634472	5.2%
u	634472	5.2%
m	317236	2.6%
n	317236	2.6%
f	317236	2.6%
c	317236	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12113760	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	3432334	28.3%
r	2711204	22.4%
l	2076732	17.1%
s	1038366	8.6%
a	634472	5.2%
u	634472	5.2%
m	317236	2.6%
n	317236	2.6%
f	317236	2.6%
c	317236	2.6%

declared_monthly_revenue
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

0.0	1355602

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	4066806
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	1355602	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	1355602	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2711204	66.7%
.	1355602	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2711204	66.7%
Other Punctuation	1355602	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	2711204	100.0%

Value	Count	Frequency (%)
.	1355602	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4066806	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	2711204	66.7%
.	1355602	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4066806	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	2711204	66.7%
.	1355602	33.3%

first_contact_date
Categorical

HIGH CARDINALITY

Distinct	141
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

2018-04-11	106718
2018-01-22	65230
2018-01-10	49716
2018-03-30	46030
2018-05-09	44027
Other values (136)	1043881

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	13556020
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018-02-03
2nd row	2018-02-03
3rd row	2018-02-03
4th row	2018-02-03
5th row	2018-02-03

Value	Count	Frequency (%)
2018-04-11	106718	7.9%
2018-01-22	65230	4.8%
2018-01-10	49716	3.7%
2018-03-30	46030	3.4%
2018-05-09	44027	3.2%
2018-04-21	39520	2.9%
2018-05-02	38976	2.9%
2018-02-10	37214	2.7%
2018-04-03	33937	2.5%
2018-02-21	32989	2.4%
Other values (131)	861245	63.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-11	106718	7.9%
2018-01-22	65230	4.8%
2018-01-10	49716	3.7%
2018-03-30	46030	3.4%
2018-05-09	44027	3.2%
2018-04-21	39520	2.9%
2018-05-02	38976	2.9%
2018-02-10	37214	2.7%
2018-04-03	33937	2.5%
2018-02-21	32989	2.4%
Other values (131)	861245	63.5%

Most occurring characters

Value	Count	Frequency (%)
0	3260363	24.1%
-	2711204	20.0%
1	2404479	17.7%
2	2227512	16.4%
8	1404509	10.4%
4	476126	3.5%
3	357079	2.6%
5	287993	2.1%
7	191856	1.4%
6	126272	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10844816	80.0%
Dash Punctuation	2711204	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	3260363	30.1%
1	2404479	22.2%
2	2227512	20.5%
8	1404509	13.0%
4	476126	4.4%
3	357079	3.3%
5	287993	2.7%
7	191856	1.8%
6	126272	1.2%
9	108627	1.0%

Value	Count	Frequency (%)
-	2711204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13556020	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	3260363	24.1%
-	2711204	20.0%
1	2404479	17.7%
2	2227512	16.4%
8	1404509	10.4%
4	476126	3.5%
3	357079	2.6%
5	287993	2.1%
7	191856	1.4%
6	126272	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13556020	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3260363	24.1%
-	2711204	20.0%
1	2404479	17.7%
2	2227512	16.4%
8	1404509	10.4%
4	476126	3.5%
3	357079	2.6%
5	287993	2.1%
7	191856	1.4%
6	126272	0.9%

landing_page_id
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	70
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

22c29808c4f815213303f8933030604c	312272
b76ef37428e6799c421989521c0e5077	205242
4e82dd1f6d00626bda0723eef0a269a6	96500
ce1a65abd0973638f1c887a6efcfa82d	92959
40dec9f3d5259a3d2dbcdab2114fae47	78576
Other values (65)	570053

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	43379264
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	b76ef37428e6799c421989521c0e5077
2nd row	b76ef37428e6799c421989521c0e5077
3rd row	b76ef37428e6799c421989521c0e5077
4th row	b76ef37428e6799c421989521c0e5077
5th row	b76ef37428e6799c421989521c0e5077

Value	Count	Frequency (%)
22c29808c4f815213303f8933030604c	312272	23.0%
b76ef37428e6799c421989521c0e5077	205242	15.1%
4e82dd1f6d00626bda0723eef0a269a6	96500	7.1%
ce1a65abd0973638f1c887a6efcfa82d	92959	6.9%
40dec9f3d5259a3d2dbcdab2114fae47	78576	5.8%
0d6bc3c00e4e64927cae2e8d9c6a0b9b	60214	4.4%
f017be4dbf86243af5c1ebed0cff36a2	45938	3.4%
358adb2fee9a122549618e46925a00a5	37562	2.8%
a0fbc0263cb98bdb0d72b9f9f283a172	37336	2.8%
a7982125ff7aa3b2054c6e44f9d28522	32155	2.4%
Other values (60)	356848	26.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
22c29808c4f815213303f8933030604c	312272	23.0%
b76ef37428e6799c421989521c0e5077	205242	15.1%
4e82dd1f6d00626bda0723eef0a269a6	96500	7.1%
ce1a65abd0973638f1c887a6efcfa82d	92959	6.9%
40dec9f3d5259a3d2dbcdab2114fae47	78576	5.8%
0d6bc3c00e4e64927cae2e8d9c6a0b9b	60214	4.4%
f017be4dbf86243af5c1ebed0cff36a2	45938	3.4%
358adb2fee9a122549618e46925a00a5	37562	2.8%
a0fbc0263cb98bdb0d72b9f9f283a172	37336	2.8%
a7982125ff7aa3b2054c6e44f9d28522	32155	2.4%
Other values (60)	356848	26.3%

Most occurring characters

Value	Count	Frequency (%)
0	3957871	9.1%
2	3941763	9.1%
3	3493220	8.1%
8	3329358	7.7%
9	2981093	6.9%
c	2851449	6.6%
f	2584124	6.0%
6	2569170	5.9%
e	2546185	5.9%
1	2493796	5.7%
Other values (6)	12631235	29.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	29639299	68.3%
Lowercase Letter	13739965	31.7%

Most frequent character per category

Value	Count	Frequency (%)
0	3957871	13.4%
2	3941763	13.3%
3	3493220	11.8%
8	3329358	11.2%
9	2981093	10.1%
6	2569170	8.7%
1	2493796	8.4%
4	2479432	8.4%
7	2327693	7.9%
5	2065903	7.0%

Value	Count	Frequency (%)
c	2851449	20.8%
f	2584124	18.8%
e	2546185	18.5%
a	2017595	14.7%
d	1977494	14.4%
b	1763118	12.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	29639299	68.3%
Latin	13739965	31.7%

Most frequent character per script

Value	Count	Frequency (%)
0	3957871	13.4%
2	3941763	13.3%
3	3493220	11.8%
8	3329358	11.2%
9	2981093	10.1%
6	2569170	8.7%
1	2493796	8.4%
4	2479432	8.4%
7	2327693	7.9%
5	2065903	7.0%

Value	Count	Frequency (%)
c	2851449	20.8%
f	2584124	18.8%
e	2546185	18.5%
a	2017595	14.7%
d	1977494	14.4%
b	1763118	12.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43379264	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3957871	9.1%
2	3941763	9.1%
3	3493220	8.1%
8	3329358	7.7%
9	2981093	6.9%
c	2851449	6.6%
f	2584124	6.0%
6	2569170	5.9%
e	2546185	5.9%
1	2493796	5.7%
Other values (6)	12631235	29.1%

origin
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.3 MiB

organic_search	411205
paid_search	379567
unknown	239726
direct_traffic	194693
social	57226
Other values (4)	73185

Length

Max length	14
Median length	11
Mean length	11.2248064
Min length	5

Characters and Unicode

Total characters	15216370
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	unknown
3rd row	unknown
4th row	unknown
5th row	unknown

Value	Count	Frequency (%)
organic_search	411205	30.3%
paid_search	379567	28.0%
unknown	239726	17.7%
direct_traffic	194693	14.4%
social	57226	4.2%
referral	39656	2.9%
display	26115	1.9%
email	4346	0.3%
other	3068	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
organic_search	411205	30.3%
paid_search	379567	28.0%
unknown	239726	17.7%
direct_traffic	194693	14.4%
social	57226	4.2%
referral	39656	2.9%
display	26115	1.9%
email	4346	0.3%
other	3068	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	1903580	12.5%
r	1713399	11.3%
c	1648589	10.8%
i	1267845	8.3%
n	1130383	7.4%
e	1072191	7.0%
_	985465	6.5%
s	874113	5.7%
h	793840	5.2%
o	711225	4.7%
Other values (11)	3115740	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14230905	93.5%
Connector Punctuation	985465	6.5%

Most frequent character per category

Value	Count	Frequency (%)
a	1903580	13.4%
r	1713399	12.0%
c	1648589	11.6%
i	1267845	8.9%
n	1130383	7.9%
e	1072191	7.5%
s	874113	6.1%
h	793840	5.6%
o	711225	5.0%
d	600375	4.2%
Other values (10)	2515365	17.7%

Value	Count	Frequency (%)
_	985465	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14230905	93.5%
Common	985465	6.5%

Most frequent character per script

Value	Count	Frequency (%)
a	1903580	13.4%
r	1713399	12.0%
c	1648589	11.6%
i	1267845	8.9%
n	1130383	7.9%
e	1072191	7.5%
s	874113	6.1%
h	793840	5.6%
o	711225	5.0%
d	600375	4.2%
Other values (10)	2515365	17.7%

Value	Count	Frequency (%)
_	985465	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15216370	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	1903580	12.5%
r	1713399	11.3%
c	1648589	10.8%
i	1267845	8.3%
n	1130383	7.4%
e	1072191	7.0%
_	985465	6.5%
s	874113	5.7%
h	793840	5.2%
o	711225	4.7%
Other values (11)	3115740	20.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	review_id	order_id	review_score	review_creation_date	review_answer_timestamp	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	payment_sequential	payment_type	payment_installments	payment_value	order_item_id	product_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	seller_id	seller_zip_code_prefix	seller_city	seller_state	geolocation_zip_code_prefix	geolocation_lat	geolocation_lng	geolocation_city	geolocation_state	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	mql_id	sdr_id	sr_id	won_date	business_segment	lead_type	lead_behaviour_profile	business_type	first_contact_date	landing_page_id	origin
0	0	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.159003	-51.499770	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
1	1	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.153290	-51.499392	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
2	2	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.152638	-51.526814	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
3	3	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.157702	-51.518647	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
4	4	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.161894	-51.515267	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
5	5	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.143668	-51.490582	bento gonçalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
6	6	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.155803	-51.514069	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
7	7	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.160054	-51.510853	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
8	8	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.161445	-51.499826	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown
9	9	6f78e9f489a355a65ff8df35a39d3753	cd07e3ceeebd529181ed30afdf30d43f	5	2017-05-04 00:00:00	2017-05-05 19:51:22	3c96cfdac2bce85bd05840b62c0e2e8e	delivered	2017-04-21 16:37:49	2017-04-21 16:50:18	2017-04-24 17:44:09	2017-05-03 14:32:54	2017-05-23 00:00:00	1	credit_card	3	115.31	2	be0dbdc3d67d55727a65d4cd696ca73c	2017-04-27 16:50:18	64.99	19.56	informatica_acessorios	47.0	493.0	1.0	245.0	19.0	14.0	14.0	33cbbec1e7e1044aaf11d152172c776f	95705	bento goncalves	RS	95705	-29.151736	-51.521130	bento goncalves	RS	0299fedc3f190307e87f32483a9ba4fd	95705	bento goncalves	RS	1ce04284ef15be769958c668292573b8	de63de0d10a6012430098db33c679b0b	6565aa9ce3178a5caf6171827af3a9ba	2018-03-06 13:27:32	household_utilities	online_big	cat	reseller	2018-02-03	b76ef37428e6799c421989521c0e5077	unknown

Last rows

	df_index	review_id	order_id	review_score	review_creation_date	review_answer_timestamp	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	payment_sequential	payment_type	payment_installments	payment_value	order_item_id	product_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	seller_id	seller_zip_code_prefix	seller_city	seller_state	geolocation_zip_code_prefix	geolocation_lat	geolocation_lng	geolocation_city	geolocation_state	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	mql_id	sdr_id	sr_id	won_date	business_segment	lead_type	lead_behaviour_profile	business_type	first_contact_date	landing_page_id	origin
1355592	1510932	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.802955	-49.385349	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355593	1510933	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.806867	-49.382462	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355594	1510934	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.806256	-49.391476	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355595	1510935	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.800081	-49.382278	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355596	1510936	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.801418	-49.389239	são josé do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355597	1510937	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.805127	-49.394409	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355598	1510938	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.816178	-49.393511	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355599	1510939	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.812500	-49.393335	são josé do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355600	1510940	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.812580	-49.389145	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social
1355601	1510941	c5aeecce6e1da6fb1058371dde6b52f3	08f037463ef8a43a35237ad2029f316b	3	2018-06-06 00:00:00	2018-06-11 13:24:51	7c29841bc24b6a0a94f8f6a9769fb54c	delivered	2018-05-22 21:30:02	2018-05-23 15:35:27	2018-05-24 15:02:00	2018-06-05 20:52:10	2018-06-06 00:00:00	1	debit_card	1	47.43	1	4501cf8b9a1915bbfb91d227cd2f1c7e	2018-05-25 15:31:33	32.99	14.44	pet_shop	55.0	1002.0	4.0	1200.0	41.0	16.0	27.0	cc63f0dd2acba93ffed4fe9f8e0321fa	15025	sao jose do rio preto	SP	15025	-20.805658	-49.386728	sao jose do rio preto	SP	489ff79f7fc2564021169d12099dd000	15025	sao jose do rio preto	SP	3cc3bc10218cf509ba24613cda41d940	0a0fb2b07d841f84fb6714e35c723075	9e4d1098a3b0f5da39b0bc48f9876645	2018-04-24 03:00:00	home_office_furniture	online_beginner	eagle	reseller	2018-04-18	40dec9f3d5259a3d2dbcdab2114fae47	social

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters